P°φkaz DROP TABLE (SQL)

p°φkaz_DROP_TABLE ::= DROP TABLE [schema.]jmΘno_tabulky [ zp∙sob ]
zp∙sob ::= CASCADE | RESTRICT

Popis

P°φkaz zruÜφ zadanou tabulku. Je-li pou₧it zp∙sob CASCADE, zruÜφ se i vÜechny pod°φzenΘ tabulky v rßmci referenΦnφ integrity. Pou₧ije-li se zp∙sob RESTRICT, tabulku se nepoda°φ smazat, je-li na nφ zßvislß jinß tabulka v rßmci referenΦnφ integrity.

OdliÜnosti od normy

• pou₧itφ CASCADE nezp∙sobφ odstran∞nφ dotaz∙ (VIEW) ani jin²ch objekt∙ schΘmatu, kterΘ zßvisφ na tΘto tabulce

P°φklad pou₧itφ:

DROP TABLE Zamestnan