Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: Print Table Format

    I want to print the format of a table. You can view the format from enterprise manager under properties, but I was wondering if there is some command that you can use in query analyser to view the stucture of a table?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can use the following:

    select * from information_schema.columns where table_name = <your_table>

    Filter out fields that you don't want to see in your output, like TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, and such.

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    Originally posted by rdjabarov
    You can use the following:

    select * from information_schema.columns where table_name = <your_table>

    Filter out fields that you don't want to see in your output, like TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, and such.

    How can I get it to display the properties of the table, for example the Data Type, Name of Column, the Size and if Nulls are allowed? All this trough query analyser.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Have you tried the query?

  5. #5
    Join Date
    Jan 2004
    Posts
    164
    Originally posted by rdjabarov
    Have you tried the query?
    Man, I feel like an idiot. Sorry about that. It does display everything I needed to know. I just did'nt scroll to teh righ tto view all information.

    Great....It works.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I was gonna post a sproc I wrote in 7 the published the catalog using sp_makewebtask...it even generated an index page..

    but now on my 2k boxes I'm getting..

    Cannot load the DLL xpweb70.dll, or one of the DLLs it references. Reason: 126(

    What gives?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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