Hi,
this following code works for SQL server. Use this sql statement
to get the column names, datatypes and lengths. Replace 'AD_REFERER'with the
table name.
Vijay
SELECT a.name as name,b.name,a.length from syscolumns a, systypes b where
a.xtype= b.xtype and
a.id =(select id from sysobjects where name = 'AD_REFERER') order by a.name
>From: "Camden Spiller" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: MS SQL and CF
>Date: Fri, 18 Aug 2000 10:27:36 -0500
>
>Does anyone know if it's possible to query a table and find out the data
>types of the fields in a table?
>
>Thanks,
>
>Camden
>
>------------------------------------------------------------------------------
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community
>or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
