YES!!! This is exactly what I needed! Huge thanks, Jamie
On Wed, 27 Mar 2002 11:34:33 -0500, in cf-talk you wrote: >Here's a standard routine I use for listing tables and columns. More info >can be found by looking up "information schema views" in SQL books Online. > ><cfquery name=get datasource=#dsn#> >select * from information_schema.columns >order by table_name, column_name ></cfquery> > ><cfoutput query=get group=table_name> >#table_name#<br> ><cfoutput> >#column_name# #data_type# #character_maximum_length#<br> ></cfoutput> ></cfoutput> > >HTH >D > > > >************************ >Diana Nichols >Webmistress >http://www.lavenderthreads.com >770.434.7374 > > >-----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 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
