SQL Server Transact Basic to Expert - Add Check constraints to existing table

Karthikeyan Anbarasan
13y
2.8k
0
0

Blog

This blog show how to add a check constraint to an exisiting table

Syntax:

ALTER TABLE tablename
WITH CHECK or WITH NOCHECK
ADD CONSTRAINT constraintname
CHECK (logicalexpression)

SQL Server Transact Basic to Expert - Add Check constraints to existing table

Up Next

SQL Server Transact Basic to Expert - Add Unique Constraints to Existing Table

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 11k people

Download Now!

Learn

View all