Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9208 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / j
Alter table table_name ENABLE constraint constraint_name;
Alter table table_name DISABLE constraint constraint_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
How can triggers be used for the table auditing?
how to create a new view in mysql? : Sql dba
Is sqlite thread safe?
What is a field in a database?
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,
what is a join? : Sql dba
How to order siblings in oracle hierarchy queries?
What is dml with example?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
What is procedure function?
What are all the common sql functions?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
