Re: database diagrams

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 10/15/04 

Date: Fri, 15 Oct 2004 16:56:16 -0400

Script your tables in Query Analyzer, instead of using Enterprise Manager to
"design" them.

Take a look at the create table statement in Books Online.

CREATE TABLE dbo.foo
(
    blatID INT NOT NULL
        FOREIGN KEY REFERENCES dbo.bar(blatID)
            ON DELETE CASCADE
) 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"John" <John@discussions.microsoft.com> wrote in message
news:FCBF114B-0887-45F7-8AE9-0BAB88FAF8E5@microsoft.com...
> No, it wouldn't have to be through a diagram.  I don't know where else in
sql
> server I can set the cascade properties.  Is there some place else?

Relevant Pages

  • Table design change makes table as read only in Query Analyzer
    ... that when using Enterprise Manager to change a ... table design, sets the table as read only when opened from Query Analyzer ... afterwards. ...
    (microsoft.public.sqlserver.server)
  • Re: query plan in clear text
    ... Personally, I do almost all tasks from Query Analyzer, and about the only ... Enterprise Manager is to deal with jobs. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: DMO SQLServer->Connect failed for user name with special characters
    ... in Enterprise Manager or Query Analyzer I get the same error. ... > Also try to put quotes around the user name (try both single quotes and ... >>> Eclipsys Corporation ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect to Query Analyzer
    ... And what happens if while you are in Enterprise Manager, ... go to the menu to Tools and then select Query Analyzer? ... noticed that I could not open Query Analyzer from within Enterprise Manager. ... to be able to change the password on my local sql server? ...
    (microsoft.public.sqlserver.connect)
  • Re: **different place for creating a new table**
    ... Both the Enterprise Manager and Query Analyzer tools allow you to specify ... specifies the owner explicitly in its internally generated script but QA ... If you want to create the tables using QA the same way EM does, specify the ...
    (microsoft.public.sqlserver.programming)