Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Alter table Rss

   Items 1 to 8 of 8   
 

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...
Rating: |  Discuss |   Briefcase | 4,227 reads

Column manipulation with ALTER TABLE

By Arno Kwetters 2015/06/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,875 reads

DEFAULT

By Umer Akram 2013/10/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,796 reads

Altering a Column

By Andre Guerreiro Neto 2012/04/25 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 3,529 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,025 reads

ALTER

By Sankar Reddy 2010/07/14 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 5,113 reads

column & data type.

By VM-723206 2009/07/23 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 5,040 reads

How to Drop Unused Empty Redundant columns

Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns  Read more...
By Chris Morton 2008/11/27 | Source: SQLServerCentral.com | Category: alter table
Rating: |  Discuss |   Briefcase | 1,150 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (4)    
alter column (2)    
metadata (2)    
databases (1)    
default constraint (1)    
empty columns (1)    
indexing (1)    
redundant columns (1)    
remove empty columns (1)    
remove redundant columns (1)    
sql server internal storage (1)    
truncate table (1)