Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9189 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
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is the difference between cluster and non cluster index? : Sql dba
What is an example of translating a date into julian format?
What is the difference between the implicit and explicit cursors?
How many commands are there in sql?
How do I debug a stored procedure?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Why is there a need for sqlcode and sqlerrm variables?
What are the sql commands?
Can we perform dml in function?
How do I run pl sql in sql developer?
explain the delete statements in sql
What are the dml statements?
What is data manipulation language?
How does pl sql work?
