CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    6

    Arrow Command to describe a table in sql server

    In Oracle we are using desc command to describe a table(to show the fields and its datatype). But in SQL Server, which command we can use to describe a table? Thanks in advance.

  2. #2
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    Re: Command to describe a table in sql server

    This should have been posted in the Database forum.

    There is a view INFROMATION_SCHEMA.COLUMNS that can be used to get the Column desccriptions of a specific table. A query like this will give the details that DESC command does in ORacle
    PHP Code:
    Select From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME 'TABLENAME' 
    @Mods : Could this be moved to the Database Forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured