Arquivo de primary key - Código Fonte

Otimização de SQL :: Converter chaves primárias em índices agrupados

–This script is designed for MS SQL Server use [insert-db-name-here] go–disable all constraints on all tables (to avoid these causing errors when altering the indexes) sp_msforeachtable ‘alter table ? nocheck …

Continuar lendo

mysql / primary key / sql

Encontre todas as tabelas sem chave primária no MySQL

USE INFORMATION_SCHEMA;SELECT TABLES.table_nameFROM TABLESLEFT JOIN KEY_COLUMN_USAGE AS c ON ( TABLES.TABLE_NAME = c.TABLE_NAME AND c.CONSTRAINT_SCHEMA = TABLES.TABLE_SCHEMA AND c.constraint_name = ‘PRIMARY’)WHERE TABLES.table_schema != ‘infomation_schema’AND c.constraint_name IS NULL;

Continuar lendo