'Liquibase : Expected something between the "TABLE" keyword and the "IF" keyword

I am trying to run the below sql by liquibase and I am getting an error expected something between "TABLE" and the keyword "IF" keyword .This is for teradata database

CREATE MULTISET TABLE IF NOT EXISTS SCHEMA_NAME.TABLE_NAME, NO, FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO AS ( I TRIED WITHOUT "AS")
(
COL1 INTEGER,
COL1 INTEGER....ETC)
PRIMARY INDEX( COL1,COL2);
teradataliquibase


Solution 1:[1]

REPLACE PROCEDURE <database_name>.drop_if_exists( in_object varchar(50)) begin IF EXISTS(
SELECT  1 
FROM    dbc.tables 
WHERE   tablename = in_object 
    and databasename='<database_name>') THEN 
CALL DBC.SysExecSQL('DROP TABLE ' || in_object); 
END IF; END;

Followed by the regular create table statment.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 access_granted

Related Questions