What are constraints? Explain different types of
constraints?

Answer Posted / 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........

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to stop log file growing too big?

574


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

630


 Explain what is sql override for a source taLle in a mapping?

572


What is master database? : SQL Server Architecture

535


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

583






Explain transaction server implicit?

522


explain different types of joins? : Sql server database administration

531


What is snapshot report?

129


What is an execution plan? How would you view the execution plan?

550


What is the data type of time?

520


What do you understand by a view?

559


What is difference between rollback immediate and with no_wait during alter database?

579


What is the syntax for encrypting a column in SQL Server?

555


What is difference between primary key and foreign key?

482


What are difference between Cluster index and Non-Cluster index?

610