T-SQL: Add column to a table with default value

by Joe Hunter 13. May 2010 10:48

Useful feature to add column to a table with a default value:

ALTER TABLE MYTABLE

ADD [MYNEWCOL] INT NOT NULL DEFAULT 0

Using T-SQL to get comma separated list of all columns in a tableDECLARE @listOfColumns VARCHAR(MAX) SET @listOfColumns = ( SELECT TOP 1 STUFF( (SELECT ', ...T-SQL: Change column type ALTER TABLE MAIN ALTER COLUMN [natFileID] NVARCHAR(30) NULL ...T-SQL: Updated extended property for a tableHandy piece of code for updating extended property for a table: Click here to download code