Home > DeveloperSection > Forums > find the all column with schema for any table in sql server
Varun Agrawal
Varun Agrawal

Total Post:3

Points:21
Posted on    March-25-2011 4:49 AM

 MSSQL Server MSSQL Server 
Ratings:


 2 Reply(s)
 1398  View(s)
Rate this:
How to find all column with schema for any table in sql server.
please give the example.
thanks in advance


Alex R
Alex R

Total Post:40

Points:280
Posted on    March-26-2011 6:20 AM

Hi Varun,

You can try this to find all column with schema for any table in sql server.

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’table_name’


Shankar M

Total Post:25

Points:175
Posted on    April-09-2013 10:05 PM

Hi Varun,

Alternatively you can try,

SP_HELP EMP in SQL Server 

Here EMP is the table name

Thanks,
Shankar

Don't want to miss updates? Please click the below button!

Follow MindStick