Create Table if doesnt exist and insert otherwise truncate

Anonymous — Tue, 25 Sep 2018 03:26:03 GMT

My current process is below

tSyBaseInput -----> tConvertType ------> tMSSqlOutput

Currently my data is loading from one database to another, with a tconverttype inbetween.

The action on the output table is Truncate Table, and Insert Data.

I am trying to meet the additional criteria;

1. If Table(output) exists then truncate and insert (Currently working)

2. If Table(output) does not exist then Create Table and Insert

And lastly, if there schema for table(output) is different from the tConvert - Drop and Create Table and Insert.

Can anyone point me in the right direction for this?

Thanks.

Re: Create Table if doesnt exist and insert otherwise truncate

fdenis — Tue, 25 Sep 2018 08:21:25 GMT

you can manage your db structure using system tables.
retrieve table ifo then chose to drop or not.