Results 1 to 2 of 2

Thread: Extract Relationships from Tables in SQL Server.....

  1. Sep 27th, 2000, 03:17 AM #1
    Samuel
    Samuel is offline

    Thread Starter
    New Member
    Join Date
    Sep 2000
    Posts
    12

    Question

    Hi,
    I am connecting with SQL server with ADODB(odbc) and I am working with vb6.
    I must extract from sql server the relationships wich there are between tables and i must extract which are the Primary Key and the Foreign Key from the tables.
    How can I do it? Can you help me with a little example?
    I want make it only by code of Visual basic 6

    thanks
    Reply With Quote Reply With Quote
  2. Sep 27th, 2000, 02:40 PM #2
    RIVES
    RIVES is offline
    Addicted Member
    Join Date
    Sep 1999
    Location
    Philippines
    Posts
    196
    Query on the sysobjects table in the SQL Server and just look from there.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width