{"id":265859,"date":"2025-02-23T08:01:19","date_gmt":"2025-02-23T07:01:19","guid":{"rendered":"https:\/\/glosarix.com\/glossary\/on-delete-en\/"},"modified":"2025-02-23T08:01:19","modified_gmt":"2025-02-23T07:01:19","slug":"on-delete-en","status":"publish","type":"glossary","link":"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/","title":{"rendered":"On Delete"},"content":{"rendered":"<p>Description: The &#8216;On Delete&#8217; action in relational databases refers to a referential integrity mechanism that defines the behavior of rows in a database when a row that is being referenced by others is deleted. This concept is fundamental for maintaining data consistency in a relational database. When a relationship between tables is established, it is common for one table to contain foreign keys pointing to primary keys in another table. The &#8216;On Delete&#8217; action allows specifying what should happen to these referenced rows when the original row is deleted. Typical options include &#8216;CASCADE&#8217;, which automatically deletes the referenced rows, &#8216;SET NULL&#8217;, which sets the foreign keys to NULL, and &#8216;RESTRICT&#8217;, which prevents deletion if references exist. This functionality is crucial to avoid creating orphaned data and to ensure that relationships between data remain logically and structurally sound. In summary, &#8216;On Delete&#8217; is a powerful tool in database management that helps developers define the behavior of relationships between tables, ensuring data integrity over time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Description: The &#8216;On Delete&#8217; action in relational databases refers to a referential integrity mechanism that defines the behavior of rows in a database when a row that is being referenced by others is deleted. This concept is fundamental for maintaining data consistency in a relational database. When a relationship between tables is established, it is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"glossary-categories":[11982],"glossary-tags":[12938],"glossary-languages":[],"class_list":["post-265859","glossary","type-glossary","status-publish","hentry","glossary-categories-sqlite-en","glossary-tags-sqlite-en"],"post_title":"On Delete ","post_content":"Description: The 'On Delete' action in relational databases refers to a referential integrity mechanism that defines the behavior of rows in a database when a row that is being referenced by others is deleted. This concept is fundamental for maintaining data consistency in a relational database. When a relationship between tables is established, it is common for one table to contain foreign keys pointing to primary keys in another table. The 'On Delete' action allows specifying what should happen to these referenced rows when the original row is deleted. Typical options include 'CASCADE', which automatically deletes the referenced rows, 'SET NULL', which sets the foreign keys to NULL, and 'RESTRICT', which prevents deletion if references exist. This functionality is crucial to avoid creating orphaned data and to ensure that relationships between data remain logically and structurally sound. In summary, 'On Delete' is a powerful tool in database management that helps developers define the behavior of relationships between tables, ensuring data integrity over time.","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>On Delete - Glosarix<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"On Delete - Glosarix\" \/>\n<meta property=\"og:description\" content=\"Description: The &#8216;On Delete&#8217; action in relational databases refers to a referential integrity mechanism that defines the behavior of rows in a database when a row that is being referenced by others is deleted. This concept is fundamental for maintaining data consistency in a relational database. When a relationship between tables is established, it is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/\" \/>\n<meta property=\"og:site_name\" content=\"Glosarix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@GlosarixOficial\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/\",\"url\":\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/\",\"name\":\"On Delete - Glosarix\",\"isPartOf\":{\"@id\":\"https:\/\/glosarix.com\/en\/#website\"},\"datePublished\":\"2025-02-23T07:01:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/glosarix.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"On Delete\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/glosarix.com\/en\/#website\",\"url\":\"https:\/\/glosarix.com\/en\/\",\"name\":\"Glosarix\",\"description\":\"T\u00e9rminos tecnol\u00f3gicos - Glosarix\",\"publisher\":{\"@id\":\"https:\/\/glosarix.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/glosarix.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/glosarix.com\/en\/#organization\",\"name\":\"Glosarix\",\"url\":\"https:\/\/glosarix.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/glosarix.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/glosarix.com\/wp-content\/uploads\/2025\/04\/Glosarix-logo-192x192-1.png.webp\",\"contentUrl\":\"https:\/\/glosarix.com\/wp-content\/uploads\/2025\/04\/Glosarix-logo-192x192-1.png.webp\",\"width\":192,\"height\":192,\"caption\":\"Glosarix\"},\"image\":{\"@id\":\"https:\/\/glosarix.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/GlosarixOficial\",\"https:\/\/www.instagram.com\/glosarixoficial\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"On Delete - Glosarix","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:\/\/glosarix.com\/en\/glossary\/on-delete-en\/","og_locale":"en_US","og_type":"article","og_title":"On Delete - Glosarix","og_description":"Description: The &#8216;On Delete&#8217; action in relational databases refers to a referential integrity mechanism that defines the behavior of rows in a database when a row that is being referenced by others is deleted. This concept is fundamental for maintaining data consistency in a relational database. When a relationship between tables is established, it is [&hellip;]","og_url":"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/","og_site_name":"Glosarix","twitter_card":"summary_large_image","twitter_site":"@GlosarixOficial","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/","url":"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/","name":"On Delete - Glosarix","isPartOf":{"@id":"https:\/\/glosarix.com\/en\/#website"},"datePublished":"2025-02-23T07:01:19+00:00","breadcrumb":{"@id":"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/glosarix.com\/en\/glossary\/on-delete-en\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/glosarix.com\/en\/"},{"@type":"ListItem","position":2,"name":"On Delete"}]},{"@type":"WebSite","@id":"https:\/\/glosarix.com\/en\/#website","url":"https:\/\/glosarix.com\/en\/","name":"Glosarix","description":"T\u00e9rminos tecnol\u00f3gicos - Glosarix","publisher":{"@id":"https:\/\/glosarix.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/glosarix.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/glosarix.com\/en\/#organization","name":"Glosarix","url":"https:\/\/glosarix.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/glosarix.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/glosarix.com\/wp-content\/uploads\/2025\/04\/Glosarix-logo-192x192-1.png.webp","contentUrl":"https:\/\/glosarix.com\/wp-content\/uploads\/2025\/04\/Glosarix-logo-192x192-1.png.webp","width":192,"height":192,"caption":"Glosarix"},"image":{"@id":"https:\/\/glosarix.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/GlosarixOficial","https:\/\/www.instagram.com\/glosarixoficial\/"]}]}},"_links":{"self":[{"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/glossary\/265859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/glossary"}],"about":[{"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/types\/glossary"}],"author":[{"embeddable":true,"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/comments?post=265859"}],"version-history":[{"count":0,"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/glossary\/265859\/revisions"}],"wp:attachment":[{"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/media?parent=265859"}],"wp:term":[{"taxonomy":"glossary-categories","embeddable":true,"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/glossary-categories?post=265859"},{"taxonomy":"glossary-tags","embeddable":true,"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/glossary-tags?post=265859"},{"taxonomy":"glossary-languages","embeddable":true,"href":"https:\/\/glosarix.com\/en\/wp-json\/wp\/v2\/glossary-languages?post=265859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}