They are handled through the extended properties. You have to use stored
procedures to manipulate them, and a SQL function to view them. Here is
the script that Query Analyzer generated after I added a description to the
DEPLOYED column of a table named NOC:
exec sp_addextendedproperty N'MS_Description', N'This is a description.',
N'user', N'dbo', N'table', N'NOC', N'column', N'DEPLOYED'
BOL has all the details, you might want to start with "Creating and
Maintaining Databases" / "User-Defined Functions" / "Using Extended
Properties on Database Objects".
|------------------+------------------------------------------------------|
|Eric A. Laney |"You know how Einstein got bad grades as a kid? Well, |
|Systems Architect |MINE are even WORSE!" |
|Verizon Security | |
|Voice: | |
|813.987.1416 | Calvin|
|Pager: | |
|888.551.3718 | |
|------------------+------------------------------------------------------|
"Kay Smoljak"
<[EMAIL PROTECTED] To: SQL <[EMAIL PROTECTED]>
.au> cc:
Subject: Column description property
of MSSQL 2K?
03/12/2002 10:25
AM
Please respond to
sql
Hi all,
Does anyone know where the description property for columns in MSSQL 2K
databases are stored? I'm presuming it's somewhere in one of the system
tables, but I can't seem to find it. I want to create some kind of xml
auto-documenting thang, pulling the name, datatype and description for
each column in each table. I don't suppose there's a built in SP that
gets that kind of info already?
Thanks,
Kay.
__________________________________________________
Kay Smoljak - Web Developer - PerthWeb Pty Ltd
http://developer.perthweb.com.au - CF custom tags
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
