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

Total Post:3

Points:21

 2090  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. 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. 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

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.