Answer / reva ram sahu

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

When we should use and scope of @@identity?

0 Answers  

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

Can select statements be used on views in ms sql server?

0 Answers  

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

How does stuff differ from the replace function?

0 Answers  

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---

between cast and convert which function would you prefer and why?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---

What is the Control Flow in SSIS

0 Answers   HCL,

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---