How do I use cascade delete with SQL Server?

by

You will need to,

  • Drop the existing foreign key constraint,
  • Add a new one with the ON DELETE CASCADE setting enabled.

Something like:

ALTER TABLE dbo.T2
   DROP CONSTRAINT FK_T1_T2   -- or whatever it's called

ALTER TABLE dbo.T2
   ADD CONSTRAINT FK_T1_T2_Cascade
   FOREIGN KEY (EmployeeID) REFERENCES dbo.T1(EmployeeID) ON DELETE CASCADE

More Related Contents:

  1. If condition in SQL Server 2008
  2. How to get the last row from a table in SQL Server?
  3. Comma separated results in SQL
  4. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  5. When should I use semicolons in SQL Server?
  6. How to get Time from DateTime format in SQL?
  7. Replace duplicate spaces with a single space in T-SQL
  8. Select values from XML field in SQL Server 2008
  9. SQL Server Pivot Table with multiple column aggregates
  10. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  11. How do I exclude Weekend days in a SQL Server query?
  12. Defining a one-to-one relationship in SQL Server
  13. How do I get date/time information from a TIMESTAMP column?
  14. Is it possible to delete from multiple tables in the same SQL statement?
  15. How do I list all tables in all databases in SQL Server in a single result set?
  16. How do I copy SQL Azure database to my local development server?
  17. Can you call a webservice from TSQL code?
  18. How to safely use reserved SQL names?
  19. Comparing dates stored as varchar
  20. SQL Server: the maximum number of rows in table [closed]
  21. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  22. SQL Server 2008 Vertical data to Horizontal
  23. SSRS report definition is newer than Server
  24. Joining multiple tables returns NULL value
  25. Which join syntax is better?
  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