DROP ONLINE FEATURE TABLE¶

Syntax¶

DROP ONLINE FEATURE TABLE [ IF EXISTS ] <name>

Parameters¶

name

Specifies the identifier for the online feature table to drop.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Anforderungen an Bezeichner.

IF EXISTS

Specifies to not return an error if the online feature table does not exist.

Access control requirements¶

For instructions on creating a custom role with a specified set of privileges, see Erstellen von kundenspezifischen Rollen.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Übersicht zur Zugriffssteuerung.

Usage Notes¶

• When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

Examples¶

The following example drops the online feature table named my_online_feature_table:

DROP ONLINE FEATURE TABLE my_online_feature_table;

+------------------------------------------------+
| status                                         |
|------------------------------------------------|
| MY_ONLINE_FEATURE_TABLE successfully dropped. |
+------------------------------------------------+

The following example drops the online feature table named my_online_feature_table if it exists:

DROP ONLINE FEATURE TABLE IF EXISTS my_online_feature_table;