SELECT "NAME", "CREATOR", CASE WHEN "TYPE" = 'T' THEN 'table' WHEN "TYPE" = 'V' THEN 'view' END AS "TYPE" FROM SYSIBM.SYSTABLES WHERE "NAME" = SELECT CO."NAME", CASE WHEN KC."COLUMN_NAME" IS NOT NULL THEN 'true' ELSE 'false' END AS "PRIMARYKEY", CASE WHEN CO."IDENTITY" = 'Y' THEN 'true' ELSE 'false' END AS "IDENTITY", CASE WHEN CO."NULLS" = 'Y' THEN 'true' ELSE 'false' END AS "NULL", CO."COLTYPE", CO."LENGTH", CO."DEFAULT" FROM SYSIBM.SYSCOLUMNS AS CO LEFT JOIN SYSIBM.SQLPRIMARYKEYS AS KC ON CO."TBNAME" = KC."TABLE_NAME" AND CO."NAME" = KC."COLUMN_NAME" WHERE CO."TBNAME" = ORDER by CO."COLNO"