find the all column with schema for any table in sql server

Total Post:3

Points:21
 1915  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. 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’

      Modified On Mar-29-2018 11:57:48 PM
  1. 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