Friday, 15 February 2013

What are the SQL Constraints

SQL Constraints
Constraints are the rules enforced on a Table Colulmns to limit the type of data that can go into a table.
Constraints can be specified when a table is created with the CREATE TABLE statement and after the table is created, we can add or modify them with the ALTER TABLE statement.

The following are constraints:

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts