I need to drop all indexes and constraints and do some processing, after thar I have to apply same indexes and constraints again using MYSql.Please help.
Please suggest if there is some way to store the information/metadata of index created.
Asked
Active
Viewed 36 times
0
-
Check the table Information_Schema.Referential_Constraints in mysql – aΨVaN Apr 15 '14 at 04:48
-
Why can't you *`disable keys`* and after your other operation re *`enable keys`*? – Ravinder Reddy Apr 15 '14 at 05:28
1 Answers
0
Start by disabling all constraints:
ALTER TABLE my_tbl NOCHECK CONSTRAINT ALL
Primary keys and unique constraints can't be disabled.
Then reenable them again:
ALTER TABLE my_tbl WITH CHECK CHECK CONSTRAINT ALL
SAS
- 3,943
- 2
- 27
- 48
-
By the way, is this question regarding tsql or MySQL..? You have tagged with both, but the solution would be different depending on that. – SAS Apr 16 '14 at 07:02