explain the type of contraints

Answers were Sorted based on User's Feedback

explain the type of contraints..

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

Is This Answer Correct ?    4 Yes 0 No

explain the type of contraints..

Answer / surya

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

Is This Answer Correct ?    3 Yes 0 No

explain the type of contraints..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the type of Indexes? which one is best, why?

6 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

your distribution database is full what will u do

0 Answers  

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

How to find 6th highest salary from Employee table ?

10 Answers  

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

How to handle errors in Stored Procedures.

2 Answers   Accenture,

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

How to find the last update record in SQL Server?

4 Answers