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.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-03-30 : 07:52:55
|
Seema writes "How to get field structure from SQl SERVER table?" |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-30 : 07:53:26
|
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='myTable' |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-30 : 15:49:42
|
[code]exec sp_MShelpcolumns 'authors'exec sp_help 'authors'[/code]rockmoose |
|
|
|
|
|