Defining a one-to-one relationship in SQL Server

by

One-to-one is actually frequently used in super-type/subtype relationship. In the child table, the primary key also serves as the foreign key to the parent table. Here is an example:

org_model_00

CREATE TABLE Organization
( 
     ID       int PRIMARY KEY,
     Name     varchar(200),
     Address  varchar(200),
     Phone    varchar(12)
)
GO

CREATE TABLE Customer
( 
     ID              int PRIMARY KEY,
     AccountManager  varchar(100)
)
GO

ALTER TABLE Customer
    ADD  FOREIGN KEY (ID) REFERENCES Organization(ID)
        ON DELETE CASCADE
        ON UPDATE CASCADE
GO

More Related Contents:

  1. Is it possible to use Full Text Search (FTS) with LINQ?
  2. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  3. Using NOLOCK Hint in EF4?
  4. How to get the last row from a table in SQL Server?
  5. Alias name is same as column name [closed]
  6. Understanding PIVOT function in T-SQL
  7. The order of a SQL Select statement without Order By clause
  8. Storing a file in a database as opposed to the file system?
  9. SQL Server named instance with Visual Studio 2017 Installer project
  10. How do you count the number of occurrences of a certain substring in a SQL varchar?
  11. Why is it considered bad practice to use cursors in SQL Server?
  12. Import Excel spreadsheet columns into SQL Server database
  13. CAST and IsNumeric
  14. Find index of last occurrence of a sub-string using T-SQL
  15. Hidden Features of SQL Server
  16. SQL Server 2008 Empty String vs. Space
  17. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  18. Best data store for billions of rows
  19. newid() inside sql server function
  20. How can I use a single mssql connection pool across several routes in an Express 4 web application?
  21. When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
  22. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  23. SQL Server 2008 Vertical data to Horizontal
  24. Which join syntax is better?
  25. LPAD in SQL Server 2008
  26. How to maintain the order of insertion in SQL Server
  27. Is there an “IF EXISTS” test for a linked server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. SQL Server stored procedure return code oddity

Leave a Comment