QUERY TABLE DATA INFORMATION

2003-11-11 Thread Eric Creese
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,

RE: QUERY TABLE DATA INFORMATION

2003-11-11 Thread Philip Arnold
use information_schema - it's a LOT easier select table_name from information_schema.tables Simple, isn't it? g -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 5:13 PM To: CF-Talk Subject: QUERY TABLE DATA INFORMATION I am using

RE: QUERY TABLE DATA INFORMATION

2003-11-11 Thread Mark A. Kruger - CFG
sp_tables 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

RE: QUERY TABLE DATA INFORMATION

2003-11-11 Thread Angel Stewart
Wish this could be done with MS Access :-( -Gel -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] use information_schema - it's a LOT easier select table_name from information_schema.tables Simple, isn't it? g [Todays Threads] [This Message] [Subscription]