what is Constraint? How many types of constraints in SQL ?
Answer Posted / ns
constraints are like an a right or any event which can we
apply on our table or column, or its an rule of integrity
there is an types of constraint:-
1.primary key
2.foreign key
3.unique
4.check
5.default
6.not null
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is amo? : sql server analysis services, ssas
What is the difference between drop table and truncate table?
What is it’s similarity with sql server?
What is the maximum number of index per table?
How to update values in a table with update statements in ms sql server?
How to skip remaining statements in a loop block using continue statements?
What are recommended options to be used while using db mirroring? : sql server database administration
What action plan is preferred if sql server is not responding?
How to rebuild indexes with alter index ... Rebuild?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is a not null constraint?
How to set the current database in ms sql server?
What part does database design plays a role in performance of an sql server-based application?
Explain the concept of recursive stored procedure.
How do I shrink an ldf file?