Describing a table structure

From: Jig Bhakta (Bhakta_at_discussions.microsoft.com)
Date: 01/13/05

  • Next message: samy: "Track changes made to existing stored procedure"
    Date: Thu, 13 Jan 2005 09:11:02 -0800
    
    

    Hi,

    I would like to know the syntax in MS SQL 2K for describing a table, without
    having to expand everything in the object browser.

    I know in Oracle it is: desc <table_name>;

    Thanks,

    Jig.


  • Next message: samy: "Track changes made to existing stored procedure"

    Relevant Pages

    • Re: Exception handling
      ... primary key for a new record already exists. ... That prohibits page failure, but I want to ... there is a list of the names of all the exceptions (for sql and others). ... However, if YOU expand the list, then YOU know how it ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: SQL error in SMS
      ... Is it possible to expand the colum and if so how do I find the colum and ... information on how to expand it. ... I'm a big SQL user ... > required data. ...
      (microsoft.public.sqlserver.server)
    • Re: Generate Column List
      ... Using the object browser window in SQL Query Analyzer may help you. ... connect to your database server. ... Click in your query window and hit Control/V to paste the SQL statement. ...
      (microsoft.public.sqlserver.server)
    • Re: Phonetic Full Text Search
      ... I'll try to see if I can check out SQL 2005. ... > that will expand the search terms for accented versions of the term or ... > expand for diacritics. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Expand Last Column in Query View
      ... Add sort clause to SQL ... Drag the last column header left one position to become the next to ... Expand the column until it is the size you want. ...
      (microsoft.public.sqlserver.tools)