V11.5 Update Guide

SQL Language

In This Section SQL - Create [if not exists] and Drop [if exists] SQL - SET IDENTITY_INSERT support SQL - COUNT fix and new COUNT_BIG support

SQL - Create [if not exists] and Drop [if exists]

The CREATE TABLE syntax has been expanded to avoid failure in case the table exists (during create) or does not exist (during drop). The feature is similar to syntaxes found in the MySql and Postgres dialects.

We now implement this feature for tables, indexes, procedures, triggers, and functions:

CREATE TABLE [IF NOT EXISTS]...

DROP TABLE [IF EXISTS]...

CREATE INDEX [IF NOT EXISTS]...

DROP INDEX [IF EXISTS]...

CREATE PROCEDURE [IF NOT EXISTS]...

DROP PROCEDURE [IF EXISTS]...

CREATE TRIGGER [IF NOT EXISTS]...

DROP TRIGGER [IF EXISTS]...

CREATE FUNCTION [IF NOT EXISTS]...

DROP FUNCTION [IF EXISTS]...