![]() ![]() Schema change causes the information stored in the table to change. The procedure above is completely general and will work even if the If foreign keys constraints were originally enabled, reenable them.Commit the transaction started in step 2.If foreign key constraints were originally enabled then run PRAGMAįoreign_key_check to verify that the schema change did not break.Them with whatever changes are necessary to accommodate the schema Schema change, then drop those views using DROP VIEW and recreate If any views refer to table X in a way that is affected by the. ![]() Triggers and indexes saved from step 3 above as a guide, makingĬhanges as appropriate for the alteration. Use CREATE INDEX and CREATE TRIGGER to reconstruct indexes and.Change the name of new_X to X using: ALTER TABLE new_X RENAME TO X. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |