What are the challenges you face when working across database platforms? Take the survey
Options

Add A Column To A Table With ExtendedProperty

aultmikeaultmike Posts: 43
edited July 13, 2010 4:41PM in SQL Prompt code snippets
I use this snippet when I want to add a column to a table and want to add a blurb about this columns purpose.

Getting into the habit of using the ExtendedProperty also allows me to use SQLDoc to create documentation. No brainer! ;-)

USE <DatabaseName>

BEGIN TRANSACTION
GO
ALTER TABLE dbo.<TableName> ADD <ColumnName> <DataType> NULL
GO
--The statement below allows you to add a description to the field
--you're adding so that you can use SQLDoc to generate documentation
EXEC sp_addextendedproperty N'MS_Description',
N'<Description of the purpose of the column>',
'SCHEMA', N'dbo', 'TABLE', N'<TableName>', 'COLUMN', '<ColumnName>'
GO
COMMIT
GO
Sign In or Register to comment.