SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 09/21/2005 :  07:24:07  Show Profile  Visit AskSQLTeam's Homepage
Andrew writes "How can I generate a table with field descriptions?"

Not Just a Number

15586 Posts

Posted - 09/21/2005 :  09:57:13  Show Profile
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 - 09/21/2005 :  15:15:06  Show Profile
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.

Edited by - homebrew on 09/21/2005 15:16:27
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000