Versions Compared

Old Version 1

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Create DDL for the table to be validated/altered MUST use any of the following tokens to refer to the name of the table: $OBJECT$, $TABLE$ or [TABLEOWNER].[table_name].

Without these tokens, the temporary "expected" table cannot created reliably as only these tokens can be replaced with temporary table names for the temporary table creation.

...

Note

  • The Create DDL is usually generated by a template and so these tokens need to be specified in the template itself unless using the Override Create DDL.

  • The generated Create DDL for a temporary table is validated to make sure it contains the unique temporary table name. If not for interactive validation the user is warned and given the chance to continue but

...

  • for application deployment, the validation is skipped to avoid the potential dropping of a data warehouse table

Drop Table DDL

The Drop Table DDL statement MUST use any of the following tokens to refer to the name of the table: $OBJECT$, $TABLE$. Otherwise, the dropping of the temporary table after the validate validation process may drop the actual data warehouse table.

...