Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/developer-guide/python-connector/../../sql-reference/sql/drop-index below:

Website Navigation

• Reference
• SQL command reference
• Tables, views, & sequences

DROP INDEX | Snowflake Documentation

Drops a secondary index.

See also:

CREATE INDEX , SHOW INDEXES , CREATE HYBRID TABLE , DROP TABLE , DESCRIBE TABLE , SHOW HYBRID TABLES

DROP INDEX [ IF EXISTS ] <table_name>.<index_name>

Copy

table_name

Specifies the identifier for the table.

index_name

Specifies the identifier for the index.

• This command can only be used to drop a secondary index. To drop an index that is used to enforce a UNIQUE or FOREIGN KEY constraint, use the ALTER TABLE command to drop the constraint.

• Indexes cannot be undropped.

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

Removes the secondary index c_idx on table t0:

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4