what is Constraint? How many types of constraints in SQL ?
Answer Posted / kumari
Constraint are the rules enforced on data columns on table
types of constraints:
PRIMARYKEY
FOREIGN KEY
NOT NULL
UNIQUE KEY
CHECK
DEFAULT
Check
Is This Answer Correct ? | 111 Yes | 33 No |
Post New Answer View All Answers
What is the use of “join” in sql server?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What are the components of dbms?
Explain a join?
Can two different columns be merged into single column? Show practically?
What is difference statement and preparedstatement?
Explain different types of Normalization.
What are the types of subscriptions in SQL Server replication?
what data regions are and what are the different data regions?
What are various ways to enhance the ssrs report?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is the difference between deallocate cursor and close cursor?
Explain query editor regions
What is bcnf normalization form?
What to perform pattern match with the like operator?