oracleɾ³ý±íµÄÏÂÁîÊÇʲô
oracle ɾ³ý±íµÄÏÂÁîÊÇ drop table¡£ËüÒªÇóÌṩҪɾ³ýµÄ±íÃû£¬Ó﷨Ϊ£ºdrop table table_name;Ö´ÐÐÇ°Ç뱸·ÝÊý¾Ý£¬ÓÉÓÚËüɾ³ýºó²»¿ÉÄ棻ɾ³ýÇ°Íâ¼üÔ¼Êø±ØÐèÏÈɾ³ý£»±íµÄÖ÷¼üÔ¼Êø»á±»×Ô¶¯É¾³ý£»ÕýÔÚʹÓõıí±ØÐèÏȶϿªÅþÁ¬¡£
Oracle ɾ³ý±íµÄÏÂÁî
ɾ³ý Oracle Êý¾Ý¿âÖеıíʹÓà DROP TABLE ÏÂÁî¡£¸ÃÏÂÁîµÄÓï·¨ÈçÏ£º
DROP TABLE table_name;
µÇ¼ºó¸´ÖÆ
ÆäÖУº
table_name ÊÇҪɾ³ýµÄ±íµÄÃû³Æ¡£
ʾÀý
Ҫɾ³ýÃûΪ “customers” µÄ±í£¬ÇëʹÓÃÒÔÏÂÏÂÁ
DROP TABLE customers;
µÇ¼ºó¸´ÖÆ
Ö÷Ҫ˵Ã÷£º
ÔÚɾ³ý±í֮ǰ£¬ÇëÈ·±£ÄúÒѱ¸·ÝÊý¾Ý¡£
DROP TABLE ÏÂÁîÊDz»¿ÉÄæµÄ¡£Ò»µ©É¾³ý£¬±í¼°ÆäÊý¾Ý½«ÓÀÊÀɥʧ¡£
ÈôÊDZí°üÀ¨Íâ¼üÔ¼Êø£¬Ôò±ØÐèÏÈɾ³ýÕâЩԼÊø£¬È»ºó²Å»ªÉ¾³ý±í¡£
ÈôÊDZí°üÀ¨Ö÷¼ü£¬Ôò Oracle »á×Ô¶¯É¾³ýÖ÷¼üÔ¼Êø¡£
ÈôÊDZíÕýÔÚʹÓã¬Ôò±ØÐèÏȶϿª¶Ô±íµÄÅþÁ¬£¬È»ºó²Å»ªÉ¾³ý±í¡£
ÒÔÉϾÍÊÇoracleɾ³ý±íµÄÏÂÁîÊÇʲôµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡