Types Of Constraints: * Primary Key * Foreign Key * Default * U

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

Question Posted / magesh manavalan

Answer Posted / magesh manavalan

Types Of Constraints:

* Primary Key

* Foreign Key

* Default

* Unique Key

* Not NULL

* Check

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the usage of floor function in sql server.

964

Explain about merge replications?

1024

Why we need sql server?

965

What is a join in sql? What are the types of joins?

1107

What is 1nf 2nf and 3nf?

891

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1064

How to get nth highest salary from employee table.

1163

What do you mean by normalisation?

1043

What is difference between view and materialized view?

937

what stored procedure can you use to display the current processes? : Sql server administration

1010

What to check if a User database is locked?

1071

Do you know sql server 2008 introduces automatic auditing?

980

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1004

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

945

What is self contained scalar sub query?

974