{"id":204867,"date":"2024-04-12T05:09:24","date_gmt":"2024-04-12T05:09:24","guid":{"rendered":"https:\/\/www.henryharvin.com\/blog\/?p=204867"},"modified":"2025-01-17T09:52:15","modified_gmt":"2025-01-17T09:52:15","slug":"sql-constraints-everything-you-should-know","status":"publish","type":"post","link":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/","title":{"rendered":"SQL Constraints-Everything You Should Know"},"content":{"rendered":"\n<p>Are you confident about SQL Constraints? If not, don\u2019t you worry? Here is everything you should know about SQL Constraints. Structured Query Language (SQL) is a programming language that rules and manages structured data in a database system.&nbsp;<\/p>\n\n\n\n<p>SQL Constraints are a set of rules in the database. These rules determine if you can include or remove data from the database system. Furthermore, SQL data are structured in a table and SQL Constraints are used to ensure the validity and accuracy of the data presented in the table.&nbsp;<\/p>\n\n\n\n<p>Once you set the constraints, any applied operation in the table is meant to be followed or the operation will be aborted. It means constraints are specifically required to set a rule that can be implemented throughout a database to maintain uniformity.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050518\/SQL.png\" alt=\"SQL Constraints\" class=\"wp-image-205091\" width=\"495\" height=\"286\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050518\/SQL.png 723w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050518\/SQL-300x173.png 300w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050518\/SQL-600x347.png 600w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>A quick orientation before digging into SQL Constraints:<\/strong><\/h2>\n\n\n\n<p>One of the popular Data Base Management Systems (DBMS) is a relational database. In this database, information is structured either in facts or in dimensions. Data that can be expressed in the form of mathematical equations can be considered as facts and the rest data are dimensions.&nbsp;You can gain expertise in this field with the help of  <a href=\"https:\/\/www.henryharvin.com\/blog\/online-sql-courses\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Certification Courses in India.<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Another key point is different data are collected in different tables. In a business, one can find the relation between two types of tables and in this way, relational database forms. Additionally, by applying constraints in the database, one can prevent entering corrupt data, enforce uniqueness, and document important data. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What are The Different Types of SQL Constraints:<\/strong><\/h2>\n\n\n\n<p>There are two types of SQL Constraints as follows:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Column SQL Constraints.<\/li><li>Table SQL Constraints.<\/li><\/ol>\n\n\n\n<p>As those names are referring, column constraints are only applied to specific columns of a table. On the other hand, table constraints can be applied to the whole table.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"427\" src=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/11140049\/Different-Types-of-Constraints-in-SQL-1536x640-1-1024x427.jpeg\" alt=\"SQL Constraints\" class=\"wp-image-205035\" srcset=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/11140049\/Different-Types-of-Constraints-in-SQL-1536x640-1-1024x427.jpeg 1024w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/11140049\/Different-Types-of-Constraints-in-SQL-1536x640-1-300x125.jpeg 300w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/11140049\/Different-Types-of-Constraints-in-SQL-1536x640-1-600x250.jpeg 600w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/11140049\/Different-Types-of-Constraints-in-SQL-1536x640-1-768x320.jpeg 768w, https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/11140049\/Different-Types-of-Constraints-in-SQL-1536x640-1.jpeg 1536w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Types of Column SQL Constraints are:&nbsp;<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>NOT NULL Constraint<\/li><li>UNIQUE Constraint<\/li><li>DEFAULT Constraint<\/li><li>CHECK Constraint<\/li><li>PRIMARY KEY Constraint<\/li><li>FOREIGN KEY Constraint<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Types of Table SQL Constraints are:<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>UNIQUE Constraint<\/li><li>CHECK Constraint<\/li><li>PRIMARY KEY Constraint<\/li><li>FOREIGN KEY Constraint<\/li><li>INDEX Constraint<\/li><\/ol>\n\n\n\n<p>Above all, some popular constraints are NOT NULL, UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY, and INDEX. Those who want to gain a strong grip on SQL and related fields can explore different <a href=\"https:\/\/www.henryharvin.com\/data-integration-using-sql-server-integration-services-ssis-course\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Developer Curriculum<\/a>. Let\u2019s learn about these constraints one by one in brief. Don\u2019t you worry, you\u2019ve got you.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Top 10 SQL Courses in India | Reviews Reporter\" width=\"720\" height=\"405\" src=\"https:\/\/www.youtube.com\/embed\/M14mU9k47OM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">NOT NULL SQL Constraint:&nbsp;<\/h3>\n\n\n\n<p>This SQL Constraint ensures that any row for a particular column has no null or blank value. Hence, this is very important in those cases where the column contains values like salary distribution, user ID, and sale amount.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On applying:&nbsp;<\/h4>\n\n\n\n<p>Specifying columns with NOT NULL in programming, some or each row in the columns has a blank value.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining:<\/h4>\n\n\n\n<p>&nbsp;If you deny the NOT NULL constraint during the table creation, no rows can remain void.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">UNIQUE SQL Constraint:&nbsp;<\/h3>\n\n\n\n<p>This SQL Constraint confirms that each row has a different value in the column or the table. The presented values in the rows should be different from each other. For example, you can imagine a column that contains the employee ID.&nbsp;<\/p>\n\n\n\n<p>Remember, a table can contain various column that requires UNIQUE constraints.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On applying:&nbsp;<\/h4>\n\n\n\n<p>Values can&#8217;t be repeated throughout the column or the table (since this SQL Constraint is useful for both table and column).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining:<\/h4>\n\n\n\n<p>Values can repeat ( you may think about the employee name column in this case).<\/p>\n\n\n\n<p>By the same token <a href=\"https:\/\/www.henryharvin.com\/blog\/learn-sql-basics\/\" target=\"_blank\" rel=\"noreferrer noopener\">Become an SQL Expert<\/a> by learning from the industry experts. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">PRIMARY KEY and FOREIGN KEY SQL Constraints:<\/h3>\n\n\n\n<p>The 1st SQL constraints are a combination of UNIQUE and NOT NULL constraints. The latter ensures the protection of the links between tables from getting impeded.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp;On applying PRIMARY KEY Constraint:<\/h4>\n\n\n\n<p>The rows of the column in a table have to be UNIQUE and can NOT be NULL.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining PRIMARY KEY SQL Constraint:<\/h4>\n\n\n\n<p>This rule can prevent the creation of blank cells. On removing this SQL Constraint the table or the column does not need to be unique or blank.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On applying FOREIGN KEY SQL Constraint:&nbsp;<\/h4>\n\n\n\n<p>Links connect between tables or columns to ensure alignment of the data. This SQL Constraint helps to protect this link.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining FOREIGN KEY SQL Constraint:<\/h4>\n\n\n\n<p>The purpose of this SQL Constraint is not established during the creation of tables. So, one can expect huge anomalies in data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">CHECK SQL Constraints:<\/h3>\n\n\n\n<p>To protect correct business logic throughout the columns, the cells of a table must contain CHECK constraints. Your manager doesn\u2019t need to see the Sales amount in the place of the Name of Business Development Executive column. So, one must enforce a SQL FOREIGN constraint. Since that protects data from getting inserted in the wrong column.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On applying:<\/h4>\n\n\n\n<p>Once you set secure specific columns from getting accepted wrong data on the application of this SQL constraint.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining:&nbsp;<\/h4>\n\n\n\n<p>Generally, it will be difficult to maintain uniformity throughout the column if we do not apply CHECK constraints.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">DEFAULT SQL Constraint:&nbsp;<\/h3>\n\n\n\n<p>This SQL constraint is essential for cases where you intentionally keep some cells blank by default. So, this is the opposite operation of the \u201cNOT NULL\u201d constraint.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On applying:<\/h4>\n\n\n\n<p>After you set this SQL Constraint, a default value is set if no specified value is applied in the cell.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining:<\/h4>\n\n\n\n<p>Lastly, on removing this SQL Constraint a blank cell contains a null value which may be misleading in some scenarios.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">INDEX SQL Constraint:&nbsp;<\/h3>\n\n\n\n<p>As the name suggests, this SQL Constraint helps to create indexes on a table in a relational database. Also, the INDEX Constraint helps to retrieve data from a long series of numbers, whereas SQL may take time to complete the process.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On applying:<\/h4>\n\n\n\n<p>This SQL Constraint makes the data retrieval process easier.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On declining:&nbsp;<\/h4>\n\n\n\n<p>Without applying this SQL Constraint, one can still retrieve data but fail to see indexes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Ready for the next step in your career?&nbsp;<\/strong><\/h2>\n\n\n\n<p>A leading Ed-tech company, Henry Harvin Education will help you get a  <a href=\"https:\/\/www.henryharvin.com\/sql-course\" target=\"_blank\" rel=\"noreferrer noopener\">SQL course certification.<\/a> By the time you start your journey, you are discovering one of the biggest E-learning Stages in the entire world. Meanwhile, you will find out, that Henry Harvin offers 1200+ courses across 37 classes. It has more than 600+ representatives and it operates within 13+ urban places, which participate in work with Henry Harvin.&nbsp;<\/p>\n\n\n\n<p>Another thing to remember is that we indeed are a reputable brand. We have 900+ corporate partners and also, 210+ college partners. Herny Harvin offers 7000+ live classes every month. So, what are you waiting for?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Recommended Reads<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li><a href=\"https:\/\/www.henryharvin.com\/blog\/row_number-function-in-sql-a-complete-guide\/\" target=\"_blank\" rel=\"noreferrer noopener\">Row Number Function in SQL: A Complete Guide<\/a><\/li><li><a href=\"https:\/\/www.henryharvin.com\/blog\/top-my-sql-interview-questions-and-answers\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 50 MySQL Interview Questions and Answers<\/a><\/li><li><a href=\"https:\/\/www.henryharvin.com\/blog\/learn-sql-basics\/\" target=\"_blank\" rel=\"noreferrer noopener\">What is SQL? Learn SQL Basics, SQL Full Form<\/a><\/li><li><a href=\"https:\/\/www.henryharvin.com\/blog\/online-sql-courses\/\" target=\"_blank\" rel=\"noreferrer noopener\">10 Best Online SQL Courses in 2024<\/a><\/li><li><a href=\"https:\/\/www.henryharvin.com\/blog\/difference-microsoft-sql-and-microsoft-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">Difference between SQL and Microsoft SQL Server<\/a><\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>In a fast-paced world, choosing a career that will help you land a job might be frightening. But,&nbsp; we\u2019ve got you. Henry Harvin SQL Developer Course is easy to understand and we also help you with your placement. In brief, start your journey today to learn SQL Constraints and be a certified SQL Developer to excel in your career.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>FAQs<\/strong><\/h2>\n\n\n\n<p>Q1. How do I prepare for an SQL interview?<\/p>\n\n\n\n<p>Ans.&nbsp; To give your best for SQL, you may need to focus on several topics like the following:<\/p>\n\n\n\n<p>Learn about DBMS.<\/p>\n\n\n\n<p>Different constraints.<\/p>\n\n\n\n<p>What is JOIN in SQL?&nbsp;<\/p>\n\n\n\n<p>and also, how do you elaborate JOIN in SQL?<\/p>\n\n\n\n<p>Hence, go through the above questions to ace an SQL interview.<\/p>\n\n\n\n<p>Q2. What is Data Integrity?<\/p>\n\n\n\n<p>Ans.  Let&#8217;s say, you have a table with a few students\u2019 LAST_NAMES. Provide a way in SQL to find and replace \u201cm\u201d with \u201cM\u201d present in every name.<\/p>\n\n\n\n<p>Ans. Enter the code as follows: SELECT REPLACE (LAST_NAME, \u2018m\u2019,&nbsp;\u2018M\u2019) From Student;<\/p>\n\n\n\n<p>Q3. Are SQL Developer and Data Analysts the same job?<\/p>\n\n\n\n<p>Ans. No. SQL Developer and Data Analysts have different job profiles. So, they both work in data management, but their responsibilities lie in different areas.<\/p>\n\n\n\n<p>Q4. Do I need to know Python to learn SQL?<\/p>\n\n\n\n<p>&nbsp;Ans. Both Python and SQL are important for your data analytics career. So, they are equally important. The best advice to learn one by one is to master both of them.<\/p>\n\n\n\n<p>Q5. Is Python harder than SQL?<\/p>\n\n\n\n<p>Ans. Though it is very subjective to answer, most professionals find Python more difficult than SQL.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog helps to understand the primary knowledge about SQL constraints and provides a brief description of its application. <\/p>\n","protected":false},"author":1124,"featured_media":205092,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","two_page_speed":[],"footnotes":""},"categories":[18713],"tags":[20792,20793,18712],"class_list":["post-204867","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-everything-you-need-to-know-bout-sql-constarint","tag-sql-constraints","tag-sql-developer"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Constraints - Everything You Should Know<\/title>\n<meta name=\"description\" content=\"Learn SQL Constraints quickly. Do you want to be a SQL developer? Want to know everything about SQL? Learn SQL c to become an SQL developer.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Constraints - Everything You Should Know\" \/>\n<meta property=\"og:description\" content=\"Learn SQL Constraints quickly. Do you want to be a SQL developer? Want to know everything about SQL? Learn SQL c to become an SQL developer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/\" \/>\n<meta property=\"og:site_name\" content=\"Henry Harvin Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-12T05:09:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-17T09:52:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050656\/SQL-PSD.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Basak Manjula\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@henryharvin_in\" \/>\n<meta name=\"twitter:site\" content=\"@henryharvin_in\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Basak Manjula\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/\"},\"author\":{\"name\":\"Basak Manjula\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/bea003df9d2f2bea1d30e748e2d01709\"},\"headline\":\"SQL Constraints-Everything You Should Know\",\"datePublished\":\"2024-04-12T05:09:24+00:00\",\"dateModified\":\"2025-01-17T09:52:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/\"},\"wordCount\":1423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\"},\"image\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12050656\\\/SQL-PSD.png\",\"keywords\":[\"Everything you need to know bout SQL Constarint\",\"SQL Constraints\",\"SQL Developer\"],\"articleSection\":[\"SQL Blogs | Learn More About SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/\",\"name\":\"SQL Constraints - Everything You Should Know\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12050656\\\/SQL-PSD.png\",\"datePublished\":\"2024-04-12T05:09:24+00:00\",\"dateModified\":\"2025-01-17T09:52:15+00:00\",\"description\":\"Learn SQL Constraints quickly. Do you want to be a SQL developer? Want to know everything about SQL? Learn SQL c to become an SQL developer.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12050656\\\/SQL-PSD.png\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12050656\\\/SQL-PSD.png\",\"width\":2560,\"height\":1707,\"caption\":\"SQL Constraints\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/sql-constraints-everything-you-should-know\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Blogs | Learn More About SQL\",\"item\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Constraints-Everything You Should Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/\",\"name\":\"Henry Harvin Blog\",\"description\":\"Latest Online Courses &amp; Certification Blogs\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/a86f96dfdfc6fa224445f6b651967094\",\"name\":\"George L V\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\",\"width\":445,\"height\":130,\"caption\":\"George L V\"},\"logo\":{\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/19130846\\\/cropped-Henry-harvin-logo-1.png\"},\"description\":\"George is an expert communicator. As a coordinator, senior language instructor, center head and a content writer the basic requirement at the DNA level was the same \u2013 effective communication. He discovered early in life that quality of communication makes the difference between great results and mediocre outcomes. And thus, he developed his first forte: focus on the listener and tailor the message accordingly. As he progressed in his career, he realized that the most compelling stories communicate through multi-sensory messaging - a powerful combination of visual, verbal, and intuitive content.\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/#\\\/schema\\\/person\\\/bea003df9d2f2bea1d30e748e2d01709\",\"name\":\"Basak Manjula\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12040247\\\/WhatsApp-Image-2024-04-12-at-9.32.18-AM-150x150.jpeg\",\"url\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12040247\\\/WhatsApp-Image-2024-04-12-at-9.32.18-AM-150x150.jpeg\",\"contentUrl\":\"https:\\\/\\\/hh-certificates.sgp1.digitaloceanspaces.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/12040247\\\/WhatsApp-Image-2024-04-12-at-9.32.18-AM-150x150.jpeg\",\"caption\":\"Basak Manjula\"},\"description\":\"Meet Manjula Basak, the passionate wordsmith hailing from West Bengal. With a pen as sharp as my wit, I craft tales that transport readers to exciting adventures of technical documentation or the magical land of creative writing. With 3 years of navigating the labyrinth of words, I expertly delve into technical and creative content writing. When not conjuring narratives, you might catch me lost in Art or exploring adventure movies.\",\"sameAs\":[\"www.linkedin.com\\\/in\\\/manjula-basak-578b64243\"],\"url\":\"https:\\\/\\\/www.henryharvin.com\\\/blog\\\/author\\\/manjulabasak03gmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Constraints - Everything You Should Know","description":"Learn SQL Constraints quickly. Do you want to be a SQL developer? Want to know everything about SQL? Learn SQL c to become an SQL developer.","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:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/","og_locale":"en_US","og_type":"article","og_title":"SQL Constraints - Everything You Should Know","og_description":"Learn SQL Constraints quickly. Do you want to be a SQL developer? Want to know everything about SQL? Learn SQL c to become an SQL developer.","og_url":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/","og_site_name":"Henry Harvin Blog","article_published_time":"2024-04-12T05:09:24+00:00","article_modified_time":"2025-01-17T09:52:15+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050656\/SQL-PSD.png","type":"image\/png"}],"author":"Basak Manjula","twitter_card":"summary_large_image","twitter_creator":"@henryharvin_in","twitter_site":"@henryharvin_in","twitter_misc":{"Written by":"Basak Manjula","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#article","isPartOf":{"@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/"},"author":{"name":"Basak Manjula","@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/bea003df9d2f2bea1d30e748e2d01709"},"headline":"SQL Constraints-Everything You Should Know","datePublished":"2024-04-12T05:09:24+00:00","dateModified":"2025-01-17T09:52:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/"},"wordCount":1423,"commentCount":0,"publisher":{"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094"},"image":{"@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#primaryimage"},"thumbnailUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050656\/SQL-PSD.png","keywords":["Everything you need to know bout SQL Constarint","SQL Constraints","SQL Developer"],"articleSection":["SQL Blogs | Learn More About SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/","url":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/","name":"SQL Constraints - Everything You Should Know","isPartOf":{"@id":"https:\/\/www.henryharvin.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#primaryimage"},"image":{"@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#primaryimage"},"thumbnailUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050656\/SQL-PSD.png","datePublished":"2024-04-12T05:09:24+00:00","dateModified":"2025-01-17T09:52:15+00:00","description":"Learn SQL Constraints quickly. Do you want to be a SQL developer? Want to know everything about SQL? Learn SQL c to become an SQL developer.","breadcrumb":{"@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#primaryimage","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050656\/SQL-PSD.png","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12050656\/SQL-PSD.png","width":2560,"height":1707,"caption":"SQL Constraints"},{"@type":"BreadcrumbList","@id":"https:\/\/www.henryharvin.com\/blog\/sql-constraints-everything-you-should-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.henryharvin.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Blogs | Learn More About SQL","item":"https:\/\/www.henryharvin.com\/blog\/category\/sql\/"},{"@type":"ListItem","position":3,"name":"SQL Constraints-Everything You Should Know"}]},{"@type":"WebSite","@id":"https:\/\/www.henryharvin.com\/blog\/#website","url":"https:\/\/www.henryharvin.com\/blog\/","name":"Henry Harvin Blog","description":"Latest Online Courses &amp; Certification Blogs","publisher":{"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.henryharvin.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/a86f96dfdfc6fa224445f6b651967094","name":"George L V","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png","width":445,"height":130,"caption":"George L V"},"logo":{"@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2025\/01\/19130846\/cropped-Henry-harvin-logo-1.png"},"description":"George is an expert communicator. As a coordinator, senior language instructor, center head and a content writer the basic requirement at the DNA level was the same \u2013 effective communication. He discovered early in life that quality of communication makes the difference between great results and mediocre outcomes. And thus, he developed his first forte: focus on the listener and tailor the message accordingly. As he progressed in his career, he realized that the most compelling stories communicate through multi-sensory messaging - a powerful combination of visual, verbal, and intuitive content."},{"@type":"Person","@id":"https:\/\/www.henryharvin.com\/blog\/#\/schema\/person\/bea003df9d2f2bea1d30e748e2d01709","name":"Basak Manjula","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12040247\/WhatsApp-Image-2024-04-12-at-9.32.18-AM-150x150.jpeg","url":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12040247\/WhatsApp-Image-2024-04-12-at-9.32.18-AM-150x150.jpeg","contentUrl":"https:\/\/hh-certificates.sgp1.digitaloceanspaces.com\/blog\/wp-content\/uploads\/2024\/04\/12040247\/WhatsApp-Image-2024-04-12-at-9.32.18-AM-150x150.jpeg","caption":"Basak Manjula"},"description":"Meet Manjula Basak, the passionate wordsmith hailing from West Bengal. With a pen as sharp as my wit, I craft tales that transport readers to exciting adventures of technical documentation or the magical land of creative writing. With 3 years of navigating the labyrinth of words, I expertly delve into technical and creative content writing. When not conjuring narratives, you might catch me lost in Art or exploring adventure movies.","sameAs":["www.linkedin.com\/in\/manjula-basak-578b64243"],"url":"https:\/\/www.henryharvin.com\/blog\/author\/manjulabasak03gmail-com\/"}]}},"views":730,"_links":{"self":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/204867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/users\/1124"}],"replies":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/comments?post=204867"}],"version-history":[{"count":1,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/204867\/revisions"}],"predecessor-version":[{"id":229978,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/posts\/204867\/revisions\/229978"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/media\/205092"}],"wp:attachment":[{"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/media?parent=204867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/categories?post=204867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.henryharvin.com\/blog\/wp-json\/wp\/v2\/tags?post=204867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}