Sorry to ask... but... What does the N' in N'user', N'dbo' etc., etc. stand for?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:06 AM To: SQL Subject: Re: Column description property of MSSQL 2K? 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 ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
