SQL Server - setting relationships through the enterprise manager
Asked By Shay
20-Nov-09 12:17 AM
I have very new to SQL Server and the Enterprise Manager. Can anyone
point me to how to set up the relationships between the tables, and
denoting which are the foreign keys?
I am coming from an Access 2k background, it that makes a difference.
Regards,
Shay B.
SQL Server
(1)
Foreign
(1)
ShalomYou
(1)
Analyser
(1)
Windows
(1)
Analiyzer
(1)
Etablish
(1)
Shalom
(1)
Shay replied to Shay
It might help to note that I am in SQL Server 7.0
Shay B.
Uri Dimant replied to Shay
Shay , shalom
You can use Enterprise Manager (diagram) folder to set relationship between
tables or write a script in query analiyzer
It might help to note that I am in SQL Server 7.0
Shay B.
Sylvain Lafontaine replied to Shay
To do that graphically, you must create one or more a DIAGRAM. Insert the
tables that you want on the Diagram and you can then etablish your
relationships graphically. When inserting one or more tables onto the
Diagram, the EM should show you the existing relationships that has been
created using scripts.
Learning how to do that with a script (that you could run in the Query
Analyser for example) would also be a good idea.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
script in 2005 cannot be run on sql server 2000 SQL Server for e.g. in 2005 SELECT * FROM sys.foreign_keys. . . . .(no error) in sql server 2000 SELECT * FROM sys.foreign_keys. . . . .(Invalid object name 'sys.foreign_keys'.) SELECT * FROM sys.indexes WHERE object_id = . . . . . . . . . (no problem in sql server 2005, but have problem in sql server 2000) so how to handle these case? Is
about autentisering SQL Server Hello! I have two questions I just wonder if I use window autentisering for a SQL server on a server where I can log in to how can SQL Server let me do so. I assume that SQL Server will not insert any kind of window account into the SQL Server database. So
SQL 2005 Express to SQL Server 2000 SQL Server Hi everyone, I have an SQL Server 2005 Express database as part of a Visual Studio project. I also have an SQL Server 2005 server. I'm trying to backup and restore my database to my web
How to extract column information of a table using T-sql SQL Server Hi folks, Please advise how to extract column information of a table using T-sql. thanks. PeterK SQL Server Programming Discussions SQL Server 2005 (1) SQL Server (1) UNION ALL (1) NOT NULL (1) Grouping (1) Decimal (1
Alter Table Add Identity SQL Server SQL Server 2000. Is there any easy way to alter an existing table so that its INT achieved, but if we work together, I know we can discover the secrets." - - The Emperor SQL Server Programming Discussions SQL Server (1) CONSTRAINT (1) ALTER TABLE (1) CREATE TABLE (1) PRIMARY KEY (1) LINQ (1) Column