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 an sql server agent?

1054

Explain various On-Delete options in a DB table. Which is the default option?

1457

What is a non clustered primary key?

917

What is the full meaning of dml?

945

application server is slow what may be the problem

2212

How to count rows with the count(*) function in ms sql server?

1005

What is difference between group by and having?

941

Give an example of SQL injection attack ?

1000

How to delete multiple rows with one delete statement in ms sql server?

998

What are the tool windows in sql server management studio? : sql server management studio

1064

What is the difference between ddl,dml and dcl commands?

1106

When would you use sql joins?

946

What is snapshot parameter in ssrs?

150

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

982

What happens if we shrink log file in sql server?

973