Constraints are used to limit the type of data that can go into a table.

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

Question Posted / scornguy

Answer Posted / scornguy

Constraints are used to limit the type of data that can go
into a table.

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Is This Answer Correct ?

225 Yes

29 No

Please Help Members By Posting Answers For Below Questions

Can I run multiple instances of sql server 2000 at the same time on one computer?

1121

in the physical file layout, where should the transaction log be stored in relation to the data file?

1043

How to enable/disable indexes?

1124

can we have a nested transaction? : Sql server database administration

1193

what are the new features introduced in sql server 2000? : Sql server database administration

980

What are the different types of Indexes available in SQL Server?

1057

How would you go about developing a ssrs report?

174

Explain the various types of concurrency problem?

1241

How to create new tables with "create table" statements in ms sql server?

1108

Can two tables share the same primary key?

984

What are types of subqueries?

1133

What is left outer join in sql server joins?

1108

Difference between LEN() and DATALENGTH() in sql server ?

1172

When I run the sql server 2000 setup, it just hangs. What do I do?

1129

User wants only to display only pdf as export option in report manager. How to achieve this?

269