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

What is the maximum length of an alert name?

1001

What do you understand by the analysis services in sql server?

939

What you can do to delete a table without the delete trigger firing?

973

What are the different types of collation sensitivity in sql server?

1113

Does windows server 2016 come with sql server?

938

What is purpose of normalization?

950

How to set database to be read_only in ms sql server?

1011

What is the difference in accessing db between sql server vs sql azure?

174

Scalability, Availability, Integration with internet, etc.)?

2879

What is difference in performance between insert top (n) into table and using top with insert?

1046

What is a subquery in a select query statement in ms sql server?

1132

How you can get the list of largest tables in a database?

1016

What happens if we shrink log file in sql server?

983

Explain about Joins?

993

what is blocking? : Sql server database administration

1043