{"id":9162,"date":"2019-02-05T10:15:36","date_gmt":"2019-02-05T10:15:36","guid":{"rendered":"https:\/\/dbtut.com\/?p=9162"},"modified":"2019-02-05T10:15:36","modified_gmt":"2019-02-05T10:15:36","slug":"the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/","title":{"rendered":"The constraint &#8216;PK_X&#8217; is being referenced by table &#8216;X&#8217;, foreign key constraint &#8216;FK_X&#8217;"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>If there is a primary key foreign key relationship between two tables, you cannot delete the primary key without deleting the foreign key. When you want to delete you receive the error as follows.<\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 3725, Level 16, State 0, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>The constraint &#8216;PK_Person&#8217; is being referenced by table &#8216;PersonDetails&#8217;, foreign key constraint &#8216;FK_PersonDetails_Person&#8217;.<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 3727, Level 16, State 0, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Could not drop constraint. See previous errors.<\/em><\/span><\/p>\n<p id=\"SspCGlO\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9164  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png\" alt=\"\" width=\"743\" height=\"387\" \/><\/p>\n<p><strong>With TSQL:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">USE [TestDB]\r\nGO\r\nALTER TABLE [dbo].[Person] DROP CONSTRAINT [PK_Person] WITH ( ONLINE = OFF )\r\nGO<\/pre>\n<p><span style=\"color: #ff0000;\"><em>Msg 3725, Level 16, State 0, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>The constraint &#8221; is being referenced by table &#8221;, foreign key constraint &#8221;.<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Msg 3727, Level 16, State 0, Line 3<\/em><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><em>Could not drop constraint. See previous errors.<\/em><\/span><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9162\" class=\"pvc_stats all  \" data-element-id=\"9162\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; If there is a primary key foreign key relationship between two tables, you cannot delete the primary key without deleting the foreign key. When you want to delete you receive the error as follows. Msg 3725, Level 16, State 0, Line 3 The constraint &#8216;PK_Person&#8217; is being referenced by table &#8216;PersonDetails&#8217;, foreign key constraint &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9162\" class=\"pvc_stats all  \" data-element-id=\"9162\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"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":[1927],"class_list":["post-9162","post","type-post","status-publish","format-standard","","category-mssql","tag-is-being-referenced-by-table"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The constraint &#039;PK_X&#039; is being referenced by table &#039;X&#039;, foreign key constraint &#039;FK_X&#039; - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The constraint &#039;PK_X&#039; is being referenced by table &#039;X&#039;, foreign key constraint &#039;FK_X&#039;\" \/>\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\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The constraint &#039;PK_X&#039; is being referenced by table &#039;X&#039;, foreign key constraint &#039;FK_X&#039; - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The constraint &#039;PK_X&#039; is being referenced by table &#039;X&#039;, foreign key constraint &#039;FK_X&#039;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-05T10:15:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"The constraint &#8216;PK_X&#8217; is being referenced by table &#8216;X&#8217;, foreign key constraint &#8216;FK_X&#8217;\",\"datePublished\":\"2019-02-05T10:15:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\"},\"wordCount\":114,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png\",\"keywords\":[\"is being referenced by table\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\",\"name\":\"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X' - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png\",\"datePublished\":\"2019-02-05T10:15:36+00:00\",\"description\":\"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X'\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png\",\"width\":1080,\"height\":563},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The constraint &#8216;PK_X&#8217; is being referenced by table &#8216;X&#8217;, foreign key constraint &#8216;FK_X&#8217;\"}]},{\"@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":"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X' - Database Tutorials","description":"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X'","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\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/","og_locale":"en_US","og_type":"article","og_title":"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X' - Database Tutorials","og_description":"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X'","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-05T10:15:36+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"The constraint &#8216;PK_X&#8217; is being referenced by table &#8216;X&#8217;, foreign key constraint &#8216;FK_X&#8217;","datePublished":"2019-02-05T10:15:36+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/"},"wordCount":114,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png","keywords":["is being referenced by table"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/","name":"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X' - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png","datePublished":"2019-02-05T10:15:36+00:00","description":"The constraint 'PK_X' is being referenced by table 'X', foreign key constraint 'FK_X'","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5961d5cf579.png","width":1080,"height":563},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/the-constraint-pk_x-is-being-referenced-by-table-x-foreign-key-constraint-fk_x\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The constraint &#8216;PK_X&#8217; is being referenced by table &#8216;X&#8217;, foreign key constraint &#8216;FK_X&#8217;"}]},{"@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\/9162","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=9162"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9162\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}