SELECT database() as DATABASE_NAME, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = database() AND TABLE_NAME = SELECT DISTINCT COLUMN_NAME as name, CASE WHEN UPPER(COLUMN_KEY) = 'PRI' THEN 'true' ELSE 'false' END as primaryKey, CASE WHEN UPPER(EXTRA) = 'AUTO_INCREMENT' THEN 'true' ELSE 'false' END as identity, CASE WHEN UPPER(IS_NULLABLE) = 'YES' THEN 'true' ELSE 'false' END as nullable, DATA_TYPE as dbDataType, CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN 0 ELSE CHARACTER_MAXIMUM_LENGTH END as length, COLUMN_DEFAULT as 'default' FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = Database() AND TABLE_NAME = ORDER BY ORDINAL_POSITION