what is Constraint? How many types of constraints in SQL ?
Answer Posted / rehan khan
constraint enforces rules at the table level and prevent the deletion of a table if there are dependencies .
constraint type:
primary key
foreign key
unique
not null
null
check
constraints can be defined at the time of table creation or after table has been created.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the properties of the transaction?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How can we rewrite sub-queries into simple select statements or with joins?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is the use of commit?
Can you pass expressions to function parameters?
How to skip remaining statements in a loop block using continue statements?
What is triggers and its types?
What is db stored procedure?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How do I find query history in sql server?
What are data driven subscriptions?
How do you open a cluster administrator?
How to create a view on an existing table in ms sql server?
What is a dbms wizard?