@Override public Sql[] generateSql( GetViewDefinitionStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) { try { String sql = "select isnull(object_definition(OBJECT_ID(object_id)), view_definition) from sys.objects, sys.schemas, INFORMATION_SCHEMA.VIEWS where objects.type='v' and upper(objects.name)='" + statement.getViewName().toUpperCase() + "'"; sql += " and objects.schema_id=schemas.schema_id and schemas.name='" + database.convertRequestedSchemaToSchema(statement.getSchemaName()) + "'"; sql += " AND upper(table_name)='" + statement.getViewName().toUpperCase() + "'"; // if (StringUtils.trimToNull(schemaName) != null) { sql += " and table_schema='" + database.convertRequestedSchemaToSchema(statement.getSchemaName()) + "'"; sql += " and table_catalog='" + database.getDefaultCatalogName() + "'"; // log.info("GetViewDefinitionSQL: "+sql); return new Sql[] {new UnparsedSql(sql)}; } catch (DatabaseException e) { throw new UnexpectedLiquibaseException(e); } }