Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-21 : 07:24:07
|
| Andrew writes "How can I generate a table with field descriptions?" |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
homebrew
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. |
 |
|
|
|
|
|
Description