SELECT database() as DATABASE_NAME, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = database() AND TABLE_NAME = SELECT COLUMN_NAME as name, CASE WHEN COLUMN_KEY = 'PRI' THEN 'true' ELSE 'false' END as primaryKey, CASE WHEN EXTRA = 'auto_increment' THEN 'true' ELSE 'false' END as identity, CASE WHEN 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