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

کد:

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 */);