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
how you can list all the tables in a database?
Does a server store data?
What are data resources?
Differentiate sql server reporting services vs. Crystal reports?
What is clustered primary key?
How to delete existing triggers using "drop trigger"?
What are the differences between ms sql server & oracle?
Which are ddl commands?
How to get the query of a table in sql server?
What are the five characteristics of good data?
Explain something about security and SQL Azure?
Tell me the difference between clustered and non-clustered index?
What are the differences between local and global temporary tables?
Why use stored procedures in sql server?
Which sql server table is used to hold the stored procedure scripts?