Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9146 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
Is there a 64 bit version of ssms?
What is sql clause?
what is denormalization. : Sql dba
What is relationship? How many types of relationship are there?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is database white box testing and black box testing?
How can get second highest salary in sql?
How to test for null values?
what are all the different normalizations? : Sql dba
What is trigger in pl sql?
what is the different between now() and current_date()? : Sql dba
what is commit? : Sql dba
Explain the commit statement.
What is the file extension for sql database?
What is implicit cursor in pl sql?
