Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9055 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 the difference between sql and t-sql? : Transact sql
what are the difference between clustered and a non-clustered index? : Sql dba
Is sql sequential or random?
what is the functionality of the function htmlentities? : Sql dba
how to extract a unit value from a date and time? : Sql dba
How many scalar data types are supported in pl/sql?
Is time a data type in sql?
Define overloaded procedure?
Why we use cross join?
what is a relationship and what are they? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
How do you update a value in sql?
Is sql harder than python?
Can we join tables without foreign key?
What is rowid in sql?
