P°φkaz CREATE INDEX

Indexy k databßzov²m tabulkßm

P°φkaz DROP INDEX (SQL)

p°φkaz_DROP_INDEX ::= DROP INDEX jmΘno_indexu FROM [schema.]jmΘno_tabulky

Popis

P°φkaz DROP INDEX zruÜφ index zadan² jmΘnem jmΘno indexu k tabulce jmΘno tabulky.

OdliÜnosti od normy

• p°φkaz DROP INDEX nenφ v SQL zaveden

P°φklady pou₧itφ:

DROP INDEX ind FROM Per_agen.Zamestnan
DROP INDEX penize FROM Zamestnan 

P°φkaz CREATE INDEX

Indexy k databßzov²m tabulkßm