Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9015 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
What is a pragma statement?
What is dml statement?
What are the types pl/sql code blocks?
what is the difference between nested subquery and correlated subquery?
What is coalesce in sql?
What are sql*plus environment variables?
Can we insert in sql function?
Can I call a procedure inside a function?
What does truncate mean in sql?
what is the difference between group by and order by in sql? : Sql dba
Explain the uses of a database trigger?
Is json a nosql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Does truncate table reset auto increment?
What does 0 mean in sql?
