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 a "where" clause and a "having" clause?
What is the use of @@spid?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What does ss stand for sexually?
Explain table valued parameters in sql server? Why tvp used?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
wat wil hapn if we give the both read and deny read permission to user?
what is dbcc? : Sql server database administration
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is table constraint?
What is service broker? : sql server database administration
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Can we use having clause without group by?
How to apply filtering criteria at group level with the having clause in ms sql server?
explain declarative management framework (dmf) in sql server 2008?
