query to bring back table design properties

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

query to bring back table design properties

Author

Topic

alys
Starting Member

5 Posts

Posted - 2001-11-26 : 08:47:23

Hi,

I'm looking for a query that will bring back the datatype and length of fields in a table so I can send it on to the client?
Hope someone can help.

LarsG
Constraint Violating Yak Guru

284 Posts

Posted - 2001-11-26 : 09:08:22

You can use the views in the information_schema

select *
from information_schema.columns
where table_name = 'OGRISH'

You can look up the details regarding columnnames and resulttypes in BOL

Edited by - LarsG on 11/26/2001 09:08:53

alys
Starting Member

5 Posts

Posted - 2001-11-26 : 09:13:32

Great, works a treat - thanks for your prompt reply!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources