Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    St.Petersburg, Russia
    Posts
    19

    Question Unanswered: How to make proper foreign keys in EM? And how to create tables using SQL statements?

    Hi!

    I wonder how to make right foreign keys in Enterprise Manager. I use diagram but in this case I get 'rigid' keys, so I can't delete records. But I want it to set NULL on removing records.

    And is it possible to create tables by writing SQl statements in EM? I tried but the new table didn't appear .

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: How to make proper foreign keys in EM? And how to create tables using SQL statements?

    Use Query Analyzer and you will know what are you doing (GUI does not show what it does).

Posting Permissions

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