FIND THE ALL COLUMN WITH SCHEMA FOR ANY TABLE IN SQL SERVER

Varun Agrawal

Total Post:3

Points:21
Posted by  Varun Agrawal
 1663  View(s)
Ratings:
Rate this:
How to find all column with schema for any table in sql server.
please give the example.
thanks in advance
  1. Alex R

    Post:40

    Points:280
    Re: find the all column with schema for any table in sql server

    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’

  1. Shankar M

    Post:25

    Points:175
    Re: find the all column with schema for any table in sql server

    Hi Varun,


    Alternatively you can try,

    SP_HELP EMP in SQL Server 

    Here EMP is the table name

    Thanks,
    Shankar

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!