How to check if table or view or index already exists for teradata database

General Discussion
1

Hello All,

Could someone help me with how to put a condition before the table or view creation if it already exists or not when running the liquibase.
This is for Teradata database. Any help on this is greatly appreciated.

2

Hi @despacito99 , I think you can add the condition in the script itself. I found this online, I hope this works.

  1. EXISTS in Teradata - Forget Code
  2. Teradata SQL, how to check if a table already exists (muddydogs.life)

I hope this is helpful.

3

Thank you Aditi for your response.