Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / reva ram sahu
constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dropping a database and taking a database offline?
What are the authentication modes in sql server? How can it be changed?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Where do we use trace frag?
What are the difference between primary keys and foreign keys?
Explain what is scheduled job and how to create it?
How to return the top 5 rows from a select query in ms sql server?
What is pessimistic concurrency?
What is the impact on other user sessions when creating indexes?
How to recreate an existing index in ms sql server?
What is row_number()?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is the contrast between sql and mysql?
When would you use sql joins?
