Constraints - SQL Server

·         Constraints     

                                                         

                A Constraint is nothing but a rule. We can define rules to monitor data while inserting, deleting updating in a table.                                                                               

                                                                                               

                There are 6 Types of Constraints in SQL Server.                                                                            

                1.     Primary Key Constraint,                                                                       

                2.     Unique Key Constraint                                                                         

                3.     Foreign Key Constraint                                                                        

                4.     Not null Key Constraint                                                                        

                5.     Check key Constraint                                                                            

                6.     DEFAULT key Constraint                                                                      

               

Primary Key Constraint (PK) – Primary key constraint is to maintain uniqueness in the table. PK doesn’t allow duplicates and null values.

Unique Key Constraint – Unique key is also to maintain uniqueness in the records. But you can enter one null value into the table column.

Foreign Key Constraint(FK)) – Foreign key dependent on Primary key. It allowed entering the values which are accepted by the related Primary key.  FK is used to restrict the junk data.

Not null Key Constraint - Not null key is used to restrict null values enter into the columns.

Check Key Constraint – Check key is used to enter the validated data only into the table columns. While inserting data, we can check the value s per mentioned norms or not.

DEFAULT Key Constraint – Default Key is used to enter default values into the table column incase null values entered.                

                                                                                                                               

                Interview questions:                                     

                1              What is a Constraint?.                                                   

                2              How many constraints are there in SQL Server?