Constraint are the rules enforced on data columns on table

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

Question Posted / srinivas

Answer Posted / srinivas

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 ?

28 Yes

14 No

Please Help Members By Posting Answers For Below Questions

How are the unique and primary key constraints different?

1003

How do I port a number to sql server?

980

How to rebuild master databse?

1028

What is the native system stored procedure to execute a command against all databases?

968

Explain a differential backup?

947

Define cursor locking

946

Tell me what is difference between view and materialized view?

882

Is port 1433 secure?

931

How to generate random numbers with the rand() function in ms sql server?

1046

What are different types of database indexes?

1011

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1004

Define self join?

987

Name some of the open source software that you can use in alternative to SSR?

151

How many primary keys are possible in a table?

872

How do I find sql server instance name?

914