Retrieve column data types of tables

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)

Retrieve column data types of tables

Author

Topic

celsius
Starting Member

26 Posts

Posted - 2006-08-04 : 02:13:59

How do you retrieve column data types of a database table? Query result must be like this:

DATA_TYPE COLUMN_NAME
int id
varchar(20) name
varchar(100) address

Thanks!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-08-04 : 02:30:25

make use of the INFORMATION_SCHEMA.COLUMNS

celsius
Starting Member

26 Posts

Posted - 2006-08-04 : 02:36:04

H U G E thanks kh!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources