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........

How do you know which index a table is using?

4 Answers  

What is the difference between functions and scalar functions?

0 Answers   EXL,

How to get a list all databases on the sql server?

0 Answers  

Explain what are the different index configurations a table can have?

0 Answers  

Can truncate be rolled back?

0 Answers  

What is Stored Procedure? What is Views in sql server? Difference between a User Defined Function and a Stored Procedure Difference between a primary key and a unique key? What is a join and explain different types of joins. Difference between temp table and table variable Difference between Triggers and Stored Procedures Difference between UNION ALL Statement and UNION What is COALESCE / Why do we use COALESCE? Why we use SET ROWCOUNT in Sql How many clustered index can have a table How many types of local tables in SQL SERVER Difference between DELETE and TRUNCATE What is Aggregate Functions? What is Row_Number()? What are Ranking Functions? What is NOLOCK? What is CTE? What are the Advantages of using CTE? What is the STUFF function and how does it differ from the REPLACE function? What are the difference between clustered and a non-clustered index? What are the different index configurations a table can have? Difference between a HAVING CLAUSE and a WHERE CLAUSE? Difference between SET and SELECT Provide all the built in string function of SQL SERVER Difference between char and varchar data types Define candidate key, alternate key, composite key. What are constraints? Explain different types of constraints. What is a self join? Explain it with an example. How will you convert table row to a column comma separated value

4 Answers   ACS,

where the connection string store in the database

0 Answers   HCL, Wipro,

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

How will you know when statistics on a table are obsolete?

0 Answers  

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

what is normalization? : Sql server database administration

0 Answers  

What is the difference between for trigger and after trigger?

0 Answers