DatabaseSchemaSqlDao.sql.stg

Home / util / src / main / resources / com / ning / billing / util / validation / dao / DatabaseSchemaSqlDao.sql.stg

group DatabaseSchemaSqlDao;

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;
>>