Constraint are the rules enforced on data columns on table. Five type of

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

Question Posted / mudit

Answer Posted / mudit

Constraint are the rules enforced on data columns on table.

Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

Is This Answer Correct ?

338 Yes

56 No

Please Help Members By Posting Answers For Below Questions

What are the types of subscriptions in SQL Server replication?

961

What is a constant or literal in ms sql server?

991

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

857

What is cached report?

135

What is an inner join?

914

What is scd (slowly changing dimension)? : sql server analysis services, ssas

951

What do you mean by tablesample?

1031

How to get the definition of a trigger back?

957

What are the two authentication modes in sql server?

1058

How to download and install microsoft .net framework version 2.0?

1101

What is the rdl file?

123

What is the process of indexing?

941

What is SQL Azure Data sync?

119

What is de-normalization in sql database administration? Give examples?

926

What is the synonym of join?

895