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

Answer Posted / mudit

Constraint are the rules enforced on data columns on table.

Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

Is This Answer Correct ?    338 Yes 56 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

3606


Explain about system stored procedure?

800


How do I find the default sql server instance?

734


How to use wildcard characters in like operations in ms sql server?

838


What objects does the fn_my_permissions function reports on? : sql server security

796


How much is a sql server license?

718


What do you mean by collation recursive stored procedure?

817


Define constraints and give an example of their use?

772


What is a field name?

730


What is indexing a document?

747


Explain what are magic tables in sql server?

740


What is normalization and what are the advantages of it?

737


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

880


Explain temporary table vs table variable by using cursor alternative?

757


What is xdr?

776