How do I edit a table in order to enable CASCADE DELETE?

by

Read this Microsoft article first. Read Me. I use the GUI during design so here is a picture of how it is selected in SSMS.
alt text
The syntax added to the foreign key is ” ON DELETE CASCADE “

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. Conditional WHERE clause in SQL Server
  5. How can I select the first day of a month in SQL?
  6. Multi-statement Table Valued Function vs Inline Table Valued Function
  7. SQL Server Insert if not exists
  8. GROUP BY to combine/concat a column [duplicate]
  9. Select statement to find duplicates on certain fields
  10. How to set table name in dynamic SQL query?
  11. Copy data into another table
  12. Using a Variable in OPENROWSET Query
  13. How to find current transaction level?
  14. EXISTS vs JOIN and use of EXISTS clause
  15. Check for file exists or not in sql server?
  16. Group DateTime into 5,15,30 and 60 minute intervals
  17. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  18. Why is a UDF so much slower than a subquery?
  19. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  20. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  21. Alternate of lead lag function in SQL Server 2008
  22. UNIX_TIMESTAMP in SQL Server
  23. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  24. SQL Server SELECT LAST N Rows
  25. How can I group by date time column without taking time into consideration
  26. Generate random int value from 3 to 6
  27. Add emoji / emoticon to SQL Server table
  28. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  29. How to execute a stored procedure inside a select query
  30. Using CASE Statement inside IN Clause

Leave a Comment