DatabaseSchemaSqlDao.sql.stg

Home / util / src / main / resources / org / killbill / billing / util / validation / dao / DatabaseSchemaSqlDao.sql.stg

9 lines | 312 B Blame History Raw Download

getSchemaInfo(schemaName) ::= <<
    SELECT TABLE_NAME, COLUMN_NAME, IS_NULLABLE, DATA_TYPE,
    CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE
    FROM information_schema.columns
    WHERE TABLE_SCHEMA = <if(schemaName)>schemaName<else>schema()<endif>
    ORDER BY TABLE_NAME, ORDINAL_POSITION;
>>