Category
SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
SQL Server
Not Null Constraint in SQL Server
It is not allowed to insert null values in the column.
SQL Server
Unique Constraint in SQL Server
Allow us to store unique values in a one column or two or more of columns.
SQL Server
Default Constraint In SQL Server
We have already employee1 table and if you check the Dept column it is nullable. When we try to insert a record in the table without providing a Dept column value, the Null value is assigned to the Dept column. Let's check with an example.
SQL Server
Check Constraint in SQL Server
Used to set the limit on column values.
SQL Server
Identity Column (Auto increment) in SQL Server
To avoid remembering the id of record/row we will use the identity constraint.
SQL Server