SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Alter table Rss

Search for any content tagged alter table

   Items 1 to 4 of 4   
 

Change Integer to BigInt on a Very Large Table

This article will show how to change the data type of a column when the table contains more than 1 billion records.  Read more...
By Nisarg Upadhyay 2017/11/09 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,316 reads

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,542 reads

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,542 reads

Grant Truncate Table Permissions in SQL Server without ALTER Table

How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.  Read more...
By Additional Articles 2012/01/16 | Source: MSSQLTips.com | Category: truncate table
Rating: (not yet rated)  Rate this |   Briefcase | 3,206 reads
   Items 1 to 4 of 4