Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9306 Views
- I also Faced
- E-Mail Answers
Answer Posted / muralidhar v
To Activate any integrity constraint, use Enable command
with Alter and to deactivate use disable with Alter.
To drop any constraint other than NOT NULL, use Drop
command with Alter. We can't drop not null, but we can
change it to NULL with Alter --Modify option.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Where is sql database stored?
Is left join same as inner join?
how to enter characters as hex numbers? : Sql dba
explain the delete statements in sql
What is mutating table error?
What company owns postgresql?
What does (+) mean in sql joins?
what is rollback? : Sql dba
How exception handling is done in advance pl/sql?
what are all the different normalizations? : Sql dba
How do you write a subquery?
In what condition is it good to disable a trigger?
What is the difference between instead of trigger and after trigger?
How many triggers can be applied to a table?
explain the advantages and disadvantages of stored procedure? : Sql dba
