Answer / wishpreet kaur

constraints are the restictions or boundaries.
we can categorise the constraints into 3 categories:
1. object constraints: specify that some objects depends
entirely or partially on other objects.
2. dynamic constraints: specify relationship among states
and events.
3. functional constraints: specify relationship among
operations.

Answer / manikandan elangovan

Primary key
Foreign Key
Unique Key
Not Null
Check
default

Answer / rev

3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign

Answer / taru mathur

a constraint refers to a condition or a check that is
applied to a coloumn(field)or a set of coloumns in a table.
Their are mainly five types of constarints:
1. UNIQUE CONSTRAINT
2. PRIMARY KEY CONSTRAINT
3. DEFAULT CONSTRAINT
4. CHECK CONSTRAINT
5. FOREIGN KEY CONSTRAINT

Answer / k.swathi

constraint is a mechanism which is used to stop the data entered by the end user by implementing bussiness rules.

contraint are 6 types
1)unique
2)primary key
3)check
4)null
5)not null
6)foreign key(refferential key)

Answer / md. aftab alam

It is a part of the table definition that are used to limit the values entered into its columns.its type are
1. Not null
2. Unique
3. primary key
4. Ckeck
5. Reference key

Answer / kumarcsn

basically there are two types of constraints
1.TABLE LEVEL CONSTRAINTS
2.COLUMN LEVEL CONSTRAINTS

Answer / g.rajesh(m.tech)

constrain kis a rule.
types of constriants are
1.domain constrain:
eg:chjeck,default,not null.
2.entity constraints:
eg:primary key.
unique key
3.referential constrain:
eg:foreign key

Answer / henry

Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null

Answer / vijay

there are 5 types of constraints that is as follow...
1.primary key
2.not null
3.check
4.default
5.unique
this are constraints types........

What is query optimization process?

0 Answers  

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

What are the kinds of subquery?

0 Answers  

What is stretch database in sql server?

0 Answers  

What is replace and stuff function in sql server?

0 Answers  

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

Explain some stored procedure creating best practices or guidelines?

0 Answers  

What are the new features in sql server 2016?

0 Answers  

What happens if date-only values are provided as date and time literals?

0 Answers