SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Get Field Structure
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 03/30/2005 :  07:52:55  Show Profile  Visit AskSQLTeam's Homepage
Seema writes "How to get field structure from SQl SERVER table?"

robvolk
Most Valuable Yak

USA
15688 Posts

Posted - 03/30/2005 :  07:53:26  Show Profile  Visit robvolk's Homepage
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='myTable'
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 03/30/2005 :  15:49:42  Show Profile
exec sp_MShelpcolumns 'authors'
exec sp_help 'authors'


rockmoose
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000