Dark Mode

kontentsunisukitsupu

DROP (SQL)

Chu Dian : huri-Bai Ke Shi Dian {uikipedeia(Wikipedia)}
konoJi Shi haJian Zheng Ke Neng naCan Kao Wen Xian yaChu Dian gaQuan kuShi sareteinaika, Bu Shi Fen desu. Chu Dian woZhui Jia shiteJi Shi noXin Lai Xing Xiang Shang nigoXie Li kudasai. (konotenpure-tonoShi iFang )
Chu Dian Jian Suo ?: "DROP" SQL - niyu-su * Shu Ji * sukara- * CiNii * J-STAGE * NDL * dlib.jp * ziyapansa-chi * TWL (2023Nian 11Yue )

DROPsute-tomento(Ying : DROP statement)ha, Guan Xi de-tabe-su (RDBMS) karaobuziekutowoXue Chu suru, SQLniokerude-taDing Yi Yan Yu (DDL) sute-tomentono1tsudearu. RDBMSniyoriXue Chu Ke Neng naobuziekutohaYi naru. shikashihotondonoRDBMSha, te-buru, yu-za, de-tabe-sunoGe obuziekutonoXue Chu haKe Neng dearu. PostgreSQLDeng ikutsukanoshisutemudehaDROPDeng noDDLsute-tomentonoShi Xing niBan i, Nei Bu De nitoranzakushiyonwoFa Sheng sase, ro-rubatsukugaKe Neng dearu.

DROPsute-tomentotoDELETEsute-tomentohaYi naru. Li eba, DELETEsute-tomentohate-burukaraXuan Ze saretaaruihaQuan tenode-tawoXue Chu suruga, Yi Fang DROPsute-tomentohade-tabe-sukarasonote-buruZi Ti woXue Chu suru.

Gou Wen

[Bian Ji ]
DROP obuziekutotaipu obuziekutoMing 1 [,obuziekutoMing 2***];
Zhu naobuziekutotaipu:
TABLE(Biao )
VIEW(biyu-)
INDEX(Suo Yin )
DATABASE(de-tabe-su)
USER(yu-za)

sanpuru

[Bian Ji ]

employeestoiuMing Qian note-buruwoXue Chu suru:

DROP TABLE employees;
Gai Nian
obuziekuto
SQL
Gou Cheng Yao Su
de-tabe-suZhi Pin
Guan Xi de-tabe-suGuan Li shisutemunoBi Jiao
de-tabe-suJie Sok kuraianto
kategori