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

What is the difference RDBMS and Graph Database?

1092

What are the difference between primary key and unique key? : sql server database administration

992

How to create prepared statements using odbc_prepare()?

1104

Disadvantages of the indexes?

1184

What options are available to audit login activity? : sql server security

1200

If user is owning any SQL Objects, can we drop that user

2133

How to access the inserted record of an event?

1109

Please explain go command in sql server?

1112

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

How many cores do I need for sql server 2016?

952

Explain indexed views and partitioned view with their syntax.

1194

Explain indexed views?

1030

What is indexing and its types?

1057

Tell me what is log shipping?

1032

How to create a dynamic cursor with the dynamic option?

1104