Constraint are the rules enforced on data columns on table types of cons

what is Constraint? How many types of constraints in SQL ?

Question Posted / kumari

Answer Posted / kumari

Constraint are the rules enforced on data columns on table

types of constraints:

PRIMARYKEY
FOREIGN KEY
NOT NULL
UNIQUE KEY
CHECK
DEFAULT
Check

Is This Answer Correct ?

111 Yes

33 No

Please Help Members By Posting Answers For Below Questions

Explain system rowset functions?

783

How to connect ms access to sql servers through odbc?

775

Write a sql query to sort on different column name according to the parameters passed in the function?

730

how to create a scrollable cursor with the scroll option? : Sql server database administration

826

what is datawarehouse?

887

What are the different ways you can create databases in sql server?

835

How to stop log file growing too big?

799

What are the ways available in sql server to execute sql statements?

817

What is cross join in sql server joins?

846

What are the types of resultset?

756

When would you use the stored procedures or functions?

796

Explain database normalization?

949

what is normalization? : Sql server database administration

801

How to create a local temporary stored procedure?

752

What is a covering index?

764