Re: Diagrams

From: Reza Alirezaei (anonymous_at_discussions.microsoft.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 13:43:06 -0700

How can I setup a foreign key while I'm designing a tabel???

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:O3a59pEPEHA.252@TK2MSFTNGP10.phx.gbl...
> They are a simple ERD tool for visualising the schema of your database.
> Changes to relationships in a diagram will affect your schema (it will
> prompt to warn you).If you don't have foreign key relationships setup then
> it won't be able to automatically determine the table relations.
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
>
> "Reza Alirezaei" <anonymous@discussions.microsoft.com> wrote in message
> news:e$xI1SEPEHA.1388@TK2MSFTNGP09.phx.gbl...
> > What are these diagrams in each database used for???
> > If I make a link betwwen two tables in a diagram ,,does it affect the
> > relationships??
> > Why dosn't it detect the relations between the tables??
> >
> > Thanks
> >
> >
>
>

Relevant Pages

  • Re: design question
    ... We have a database of products and we know that: ... implement in a SQL database than a foreign key. ... redundant information, but it makes easy to enforce some constraints ... simplified version of the schema, in the real database there are more ...
    (comp.databases.theory)
  • Re: design question
    ... We have a database of products and we know that: ... implement in a SQL database than a foreign key. ... redundant information, but it makes easy to enforce some constraints ... simplified version of the schema, in the real database there are more ...
    (comp.databases.theory)
  • design question
    ... I would appreciate your advice about the design of the following ... We have a database of products and we know that: ... foreign key to “part_types”. ... simplified version of the schema, in the real database there are more ...
    (comp.databases.theory)
  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)