what is Constraint? How many types of constraints in SQL ?

Answer Posted / sowndharya-bca gvg colleg

constraints are enforced on data being stored in a table
1-primary key constraint
2-foreign key constraint
3-unique key constraint


other constraints~~~~:
business rule constraints
column level constraints
table level constraints

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by intent locks?

772


What is 4nf in normalization form?

768


What are parameterized reports? What are cascading parameters in ssrs reports?

129


What is 1nf normalization form?

766


Can we take the full database backup in log shipping?

741


What is it’s similarity with sql server?

155


what is datawarehouse?

856


What is the purpose of grouping data in a report?

744


what is bit datatype? : Sql server database administration

676


Tell me what do we need queues in sql service broker?

727


What are “phantom rows”?

1425


How do I install sql server?

643


Define right outer join in sql server joins?

758


What is save transaction and save point?

863


Explain about Normalization?

811