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,
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
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
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]
4 matches
Mail list logo