Berikut Query untuk mendapatkan nama filed primary dari suatu tabel di database mysql
SELECT A.table_name, B.column_name as Column_PrimaryKey
FROM INFORMATION_SCHEMA.TABLES A,INFORMATION_SCHEMA.KEY_COLUMN_USAGE B
WHERE A.TABLE_SCHEMA = ‘test’
AND B.TABLE_SCHEMA = ‘test’
AND B.TABLE_NAME = A.TABLE_NAME
AND (B.TABLE_NAME = ‘id’ )
AND B.CONSTRAINT_NAME = ‘PRIMARY’
ORDER BY A.TABLE_NAME ASC;
Ket :
‘ test’ : adalah nama database,
‘id’ : adalah nama table
