{"id":14079,"date":"2019-12-02T06:49:03","date_gmt":"2019-12-02T06:49:03","guid":{"rendered":"https:\/\/dbtut.com\/?p=14079"},"modified":"2020-01-09T14:26:02","modified_gmt":"2020-01-09T14:26:02","slug":"on-delete-cascade-and-on-update-cascade-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/","title":{"rendered":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server"},"content":{"rendered":"

We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. You can benefit from the article “What is Primary Key and Foreign Key<\/a>“.<\/p>\n

If you have defined Foreing key as I have described in the article “What is Primary Key and Foreign Key<\/a>“, you cannot normally delete the record in the primary table without deleting the record in the table with the foreing key. When you try to delete it, you receive the error as follows.<\/p>\n

Msg 547, Level 16, State 0, Line 4<\/em><\/span><\/p>\n

The DELETE statement conflicted with the REFERENCE constraint “FK_xx”. The conflict occurred in database “xx”, table “dbo.xx”, column ‘xx’.<\/em><\/span><\/p>\n

The statement has been terminated.<\/em><\/span><\/p>\n

What is ON DELETE CASCADE<\/h2>\n

If you created the Foreign Key by specifying “ON DELETE CASCADE”, when you delete the record in the primary table, it automatically deletes the records in the child table that the foreign key is defined in. You wouldn’t get the above error. Of course, this is not always desirable. Thats why this is not the default behavior.<\/p>\n

Create Foreing Key With ON DELETE CASCADE<\/h2>\n

You can create a foreign key by specifying “ON DELETE CASCADE” with the script below.<\/p>\n

ALTER TABLE [dbo].[CityFeatures]  WITH CHECK ADD  CONSTRAINT [FK_cityfeatures_City] FOREIGN KEY([CityID])\nREFERENCES [dbo].[City] ([ID]) ON DELETE CASCADE\nGO\nALTER TABLE [dbo].[CityFeatures] CHECK CONSTRAINT [FK_cityfeatures_City]\nGO\n<\/pre>\n
What is ON UPDATE CASCADE<\/h2>\n
If you specify “ON UPDATE CASCADE” when creating Foreign Key, this ensures that when there is an update in the column in the primary table, this update is reflected in the table with the foreign key.<\/p>\n
If you did not create the Foreign Key with the ON UPDATE CASCADE, you will get an error like the following when you try to update the column referenced by foreing key in the primary table.<\/p>\n
Msg 547, Level 16, State 0, Line 4<\/em><\/span><\/p>\n
The UPDATE statement conflicted with the REFERENCE constraint “FK_xx”. The conflict occurred in database “xx”, table “dbo.xx”, column ‘xx’.<\/em><\/span><\/p>\n
The statement has been terminated.<\/em><\/span><\/p>\n
Create Foreing Key With ON UPDATE CASCADE<\/h2>\n
You can create a foreign key by specifying “ON UPDATE CASCADE” with the script below.<\/p>\n
ALTER TABLE [dbo].[CityFeatures]  WITH CHECK ADD  CONSTRAINT [FK_cityfeatures_City] FOREIGN KEY([CityID])\nREFERENCES [dbo].[City] ([ID]) ON UPDATE CASCADE\nGO\nALTER TABLE [dbo].[CityFeatures] CHECK CONSTRAINT [FK_cityfeatures_City]\nGO\n<\/pre>\n
Can we alter primary key column if we created Foreign Key With ON UPDATE CASCADE?<\/h2>\n
If you try to alter primary key column you will receive the below error.<\/p>\n
Msg 5074, Level 16, State 1, Line 8 <\/em><\/span><\/p>\n
The object ” is dependent on column ”. <\/em><\/span><\/p>\n
Msg 4922, Level 16, State 9, Line 8<\/em><\/span><\/p>\n
ALTER TABLE ALTER COLUMN failed because one or more objects access this column.<\/em><\/span><\/p>\n
If you want to change primary key column you may want to read the article name “What is Primary Key and Foreign Key<\/a>”<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. You can benefit from the article “What is Primary Key and Foreign Key“. If you have defined Foreing key as I have described in the article “What is Primary Key …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":14082,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[2712,6432,6452,6451,6457,6458,6455,6456,6444,6459,6433,6437,6435,6438,6436,6441,6453,6454,6443,6442,6450,6446,6434,6440,6439,6445],"class_list":["post-14079","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-alter-table-alter-column-failed-because-one-or-more-objects-access-this-column","tag-create-foreing-key-with-on-delete-cascade","tag-delete-cascade-and-update-cascade","tag-delete-cascade-and-update-cascade-in-sql-server","tag-difference-between-on-delete-cascade-on-update-cascade","tag-difference-between-on-delete-cascade-and-on-update-cascade","tag-foreign-keys-with-cascade-delete","tag-foreign-keys-with-cascade-update","tag-how-do-i-enable-cascade-delete-in-sql-server","tag-how-do-i-use-cascade-delete-with-sql-server","tag-on-delete-cascade","tag-on-delete-cascade-and-on-update-cascade-in-sql","tag-on-delete-cascade-and-on-update-cascade-in-sql-server","tag-on-delete-cascade-and-on-update-cascade-sql","tag-on-delete-cascade-and-on-update-cascade-sql-server","tag-on-update-cascade","tag-sql-server-foreign-keys-with-cascade-delete","tag-sql-server-foreign-keys-with-cascade-update","tag-the-delete-statement-conflicted-with-the-reference-constraint","tag-the-update-statement-conflicted-with-the-reference-constraint","tag-what-does-cascade-update-related-fields-mean","tag-what-is-cascading-in-sql","tag-what-is-on-delete-cascade","tag-what-is-on-delete-cascade-and-on-update-cascade","tag-what-is-on-update-cascade","tag-what-is-update-cascade-in-sql"],"aioseo_notices":[],"yoast_head":"\nON DELETE CASCADE and ON UPDATE CASCADE in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-02T06:49:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-09T14:26:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png\" \/>\n\t<meta property=\"og:image:width\" content=\"589\" \/>\n\t<meta property=\"og:image:height\" content=\"363\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server\",\"datePublished\":\"2019-12-02T06:49:03+00:00\",\"dateModified\":\"2020-01-09T14:26:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\"},\"wordCount\":428,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png\",\"keywords\":[\"ALTER TABLE ALTER COLUMN failed because one or more objects access this column\",\"Create Foreing Key With ON DELETE CASCADE\",\"DELETE CASCADE and UPDATE CASCADE\",\"DELETE CASCADE and UPDATE CASCADE in SQL Server\",\"Difference between On Delete Cascade & On Update Cascade\",\"Difference between On Delete Cascade and On Update Cascade\",\"Foreign Keys with cascade delete\",\"Foreign Keys with cascade update\",\"How do I enable cascade delete in SQL Server?\",\"How do I use cascade delete with SQL Server?\",\"ON DELETE CASCADE\",\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL\",\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server\",\"ON DELETE CASCADE and ON UPDATE CASCADE SQL\",\"ON DELETE CASCADE and ON UPDATE CASCADE SQL Server\",\"ON UPDATE CASCADE\",\"SQL Server: Foreign Keys with cascade delete\",\"SQL Server: Foreign Keys with cascade update\",\"The DELETE statement conflicted with the REFERENCE constraint\",\"The UPDATE statement conflicted with the REFERENCE constraint\",\"What does cascade update related fields mean?\",\"What is cascading in SQL?\",\"What is ON DELETE CASCADE\",\"What is ON DELETE CASCADE and ON UPDATE CASCADE\",\"What is ON UPDATE CASCADE\",\"What is update cascade in SQL?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\",\"name\":\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png\",\"datePublished\":\"2019-12-02T06:49:03+00:00\",\"dateModified\":\"2020-01-09T14:26:02+00:00\",\"description\":\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png\",\"width\":589,\"height\":363},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server - Database Tutorials","description":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server - Database Tutorials","og_description":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-02T06:49:03+00:00","article_modified_time":"2020-01-09T14:26:02+00:00","og_image":[{"width":589,"height":363,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server","datePublished":"2019-12-02T06:49:03+00:00","dateModified":"2020-01-09T14:26:02+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/"},"wordCount":428,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png","keywords":["ALTER TABLE ALTER COLUMN failed because one or more objects access this column","Create Foreing Key With ON DELETE CASCADE","DELETE CASCADE and UPDATE CASCADE","DELETE CASCADE and UPDATE CASCADE in SQL Server","Difference between On Delete Cascade & On Update Cascade","Difference between On Delete Cascade and On Update Cascade","Foreign Keys with cascade delete","Foreign Keys with cascade update","How do I enable cascade delete in SQL Server?","How do I use cascade delete with SQL Server?","ON DELETE CASCADE","ON DELETE CASCADE and ON UPDATE CASCADE in SQL","ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server","ON DELETE CASCADE and ON UPDATE CASCADE SQL","ON DELETE CASCADE and ON UPDATE CASCADE SQL Server","ON UPDATE CASCADE","SQL Server: Foreign Keys with cascade delete","SQL Server: Foreign Keys with cascade update","The DELETE statement conflicted with the REFERENCE constraint","The UPDATE statement conflicted with the REFERENCE constraint","What does cascade update related fields mean?","What is cascading in SQL?","What is ON DELETE CASCADE","What is ON DELETE CASCADE and ON UPDATE CASCADE","What is ON UPDATE CASCADE","What is update cascade in SQL?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/","name":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png","datePublished":"2019-12-02T06:49:03+00:00","dateModified":"2020-01-09T14:26:02+00:00","description":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-90.png","width":589,"height":363},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/02\/on-delete-cascade-and-on-update-cascade-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14079"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14082"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}