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]
- RE: QUERY TABLE DATA INFORMATION Eric Creese
- RE: QUERY TABLE DATA INFORMATION Philip Arnold
- RE: QUERY TABLE DATA INFORMATION Angel Stewart
- RE: QUERY TABLE DATA INFORMATION Mark A. Kruger - CFG