Interested to Buy Any Domain ? << Click Here >> for more details...
How will you a activate/deactivate integrity constraints?
- 2 Answers
- 9195 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 to get @@error and @@rowcount at the same time? : Sql dba
what is datawarehouse? : Sql dba
Why is pl sql needed?
Can dml statements be used in pl/sql?
How do you create a db file?
What are its different types of dbms?
What is identity column in sql server?
Can we use views in stored procedure?
i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.
what is denormalization. : Sql dba
Explain isolation levels. : Transact sql
Is sql scripting language?
-
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)
