how to query the structure of a table

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)

how to query the structure of a table

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-10 : 07:54:13

epaloid writes "hi

we are migrating from oracle9i to SQLServer 2000, and we have read Microsoft SQL Server 2000 Weekend Crash Course but there are still questions on our minds the first is how can we query the structure of a table using CLI w/o using the SQL Query Analyzer?

thanks"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-10 : 08:54:41

1 sp_help 'yourTable'
2 Select * from information_Schema.Columns where table_name='yourTable'
3 From Enterprise Manager use the option Generate SQL Script

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources