I will leave it to the SQL gurus to describe the SQL commands for this but we found a tool that is fantastic for documenting SQL2000 Databases with pretty much anything you would need.
http://www.jn-software.com/sql2000print_features.html Regards, Neil -----Original Message----- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 11:20 AM To: CF-Talk Subject: Getting field names, etc. from MSSQL 2000 Is it possible to get information about a table via SQL (or some other method)? I would like to get field names, datatypes/lengths, etc. I am using MSSQL 2000. Thanks, Jamie ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
