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
 Old Forums
 CLOSED - General SQL Server
 Get Field Structure

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'
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-03-30 : 15:49:42
[code]exec sp_MShelpcolumns 'authors'
exec sp_help 'authors'[/code]

rockmoose
Go to Top of Page
   

- Advertisement -