Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    25

    Question How to get table name, PK field, FK field from SQL Server Datbase

    I'm using VB to write a application to call SQL server database.
    i'm using ADO-ODBC to connect to the database.
    How can i get all the table name from the database, and also how can i get the primary key field, foriegn key field from a given table?

  2. #2
    Join Date
    Mar 2002
    Posts
    10

    sysobjects

    type select * from sysobjects where name=<table_name>

  3. #3
    Join Date
    Mar 2002
    Posts
    10

    sp_help

    or using stored procedure sp_help within the active database

Posting Permissions

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