Table, and Field name

[sRockyHill]

Hi,

How can I write a query that will return a table names ,a nd its field names.

something like this:
Select Name from dbo.sysobjects where xtype = 'u' AND NAME NOT IN('dtproperties')

This only return table name, I need the table names with field names.

Thank you

Salim Bhura

 

[mrdenny]

Use the information schema views.

select *
from INFORMATION_SCHEMA.TABLES
where table_name <> 'dbproperties'

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[ESquared]

Specifically, the columns one:

SELECT * FROM INFORMATION_SCHEMA.Columns

-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)

 

[mrdenny]

oh, yeah, i'm a dope and gave the wrong view name.

Denny

--Anything is possible. All it takes is a little research. (Me)