1. SqlDBM Forum
  2. Questions
0
Answered

Is the option to generate 'CREATE OR REPLACE' ddl syntax for views and tables available?

troy thomsen 3 months ago • updated by hannah gryska 3 months ago • 3

There's an enhancement request out there that's supposedly been complete for this, however I do not see it available. Is that still coming in a future release?  There's no create or replace option available from what I can see: 

Image 3471

+1
Under review
hannah gryska 3 months ago

Hi Troy, Please see the below and let me know if this helps you at all. Thank you!

  • Create - will generate DDL
  • If using for Tags: Apply tags - will apply tags on database objects being generated
  • Drop - without "Create" will generate drop statements. Together with "Create," will generate a "CREATE OR REPLACE" statement for objects.

Image

troy thomsen 3 months ago

Hi Hannah, 

Thanks!  That's the piece I was missing.  I tried it and yes, enabling BOTH the CREATE and DROP check boxes on the tables does produce the 'create or replace' ddl syntax. I had assumed the drop option would just generate a drop statement. 

Answered
hannah gryska 3 months ago

Hey Troy, it is a bit unclear - sorry about that - but glad that helped!! Have a great day.

Customer support service by UserEcho