T-SQL: Updated extended property for a table

by Joe Hunter 31. March 2010 11:46

Handy piece of code for updating extended property for a table:

T-SQL: Add column to a table with default valueUseful feature to add column to a table with a default value: Normal 0 false false false ...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 ...