Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9311 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 |
when is the use of update_statistics command? : Sql dba
What is a data definition language?
what is global table
Why do we need cursors in pl sql?
What is optimistic concurrency control? : Transact sql
Is sql a case sensitive language?
What are its different types of dbms?
What is the use of pl/sql table?
What is the difference between inner join and natural join?
What is a heap in sql?
what are date and time functions in mysql? : Sql dba
Write the order of precedence for validation of a column in a table ?
-
Oracle (3253) - 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)
