Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2005-09-21 : 07:24:07
Andrew writes "How can I generate a table with field descriptions?"

Not Just a Number

15586 Posts

Posted - 2005-09-21 : 09:57:13
Depends on what you mean by descriptions....



Hint: Want your questions answered fast? Follow the direction in this link
Go to Top of Page

Posting Yak Master

114 Posts

Posted - 2005-09-21 : 15:15:06
He probably means "Extended properties"

If you're creating the table through Enterprise Manager, then there's a "Description" field that can be filled in.

Through a script, it would be something like:

SET @v = N'Field Desription Here'
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'user', N'dbo', N'table', N'TableName', N'column', N'FieldName'

Enterprise Manager is the simplest way, but then you can generate a script of the changes you made, so you can see what the actual code is.
Go to Top of Page

- Advertisement -