Results 1 to 4 of 4

Thread: SQL statement

  1. #1
    Join Date
    Jan 2004
    Location
    none
    Posts
    4

    Unanswered: SQL statement

    Hi All,

    What is the SQL statement to run on SQL query analyzer can print out each tables' (or whole database's tables) attributes, data type and all key (primary / foreigh key) in suitable format. Thanks!

    Vw

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    sp_help table_name
    Get yourself a copy of the The Holy Book

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

  3. #3
    Join Date
    Jan 2004
    Location
    none
    Posts
    4
    Hi Emigma,

    Thanks for your help, it works ......
    Do you know where can I get those SQL commands list from web? I've tried search from the net but couldn't find it.

    Regards,
    Vincent

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Click on the link for the Holy Book in my signature .. all these commands are documented in the Holy Book (SQL Server Books Online).
    Get yourself a copy of the The Holy Book

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

Posting Permissions

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