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 the

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 the

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]