Returns tables with a qualifier for "user" and "system"... use q of a q to get at the "user" tables.
-Mark
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 4:13 PM
To: CF-Talk
Subject: QUERY TABLE DATA INFORMATION
I am using the following to get the tablename, column, datatype and length from my SQL Server DB. I only want tables.
I am having a brain fart to criteria only tables. Here is my SQL
SELECT
sysobjects.Name as Tablename,
Syscolumns.Name as Fieldname,
Systypes.Name as FieldDataType,
Syscolumns.length as FieldLength
FROM sysobjects, Syscolumns, systypes
WHERE sysobjects.ID = Syscolumns.ID
AND Syscolumns.xtype = Systypes.xtype
ORDER BY sysobjects.Name
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]