Monday , December 10 2018
Home / DataBase / SQL SERVER / Create Not Null Constraint in sql Server

Create Not Null Constraint in sql Server

Create Not Null Constraint in sql Server:

Not Null: If it is imposed on a column that column will not allow Null Values into it; this can be imposed on any no of columns.

Syntax:-

Example:-
Explanation:-  The above Example Explains you the Empid Column Not allowed Null Values, If You are trying to insert Null values It throws an error  and also Same as Salary Column.

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …