DROP TABLE

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

---

NAME

DROP TABLE - å é¤ä¸ä¸ªè¡¨

SYNOPSIS

DROP TABLE name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION æè¿°

DROP TABLE ä»æ°æ®åºä¸å é¤è¡¨æè§å¾ã åªæå¶ææèæè½å é¤ä¸ä¸ªè¡¨æè§å¾ãè¦æ¸ç©ºä¸ä¸ªè¡¨ï¼èä¸å é¤è¡¨ï¼ ä½¿ç¨ DELETEã

DROP TABLE æ»æ¯å é¤ç®æ è¡¨ä¸ç°æçä»»ä½ç´¢å¼ï¼ è§åï¼è§¦åå¨ä»¥å约æãä½æ¯ï¼è¦å é¤ä¸ä¸ªç±å¦å¤ä¸ä¸ªè¡¨ç¨å¤é®çº¦æå¼ç¨çè¡¨ï¼ æ们å¿é¡»å£°æ CASCADEãï¼CASCADE å°å é¤å¤é®çº¦æï¼èä¸æ¯å¦å¤ä¸ä¸ªè¡¨ãï¼

PARAMETERS åæ°

name

è¦å é¤çç°å表çååï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ã

CASCADE

èªå¨å é¤ä¾èµäºè¡¨ç对象ãï¼æ¯å¦è§å¾ï¼ã

RESTRICT

å¦æåå¨ä¾èµå¯¹è±¡ï¼åæç»å é¤è¯¥è¡¨ãè¿ä¸ªæ¯ç¼ºçã

EXAMPLES ä¾å

å é¤ films å distributors表ï¼

DROP TABLE films, distributors;

COMPATIBILITY å¼å®¹æ§

æ¤å½ä»¤éµå¾ª SQL æ åã

SEE ALSO åè§

ALTER TABLE [alter_table(7)], CREATE TABLE [create_table(l)]

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---