پاک شدن کلید اصلی تمامی جداول یک پایگاه داده

کد:

ALTER TABLE `myTable` ADD `myField` INT AUTO_INCREMENT PRIMARY KEY;

کد:

select table_name from information_schema.columns where table_name = 'YOUR-DB-NAME' and table_name not in
    (select table_name from information_schema.columns where table_schema = 'YOUR-DB-NAME' /* table schema OF YOUR-DB-NAME database */
        and column_key = 'PRI' /* just primary keys */
        and data_type = 'int' /* just int columns */
        and extra = 'auto_increment' /* just auto-increment value */);