sqlÖÐɾ³ý±íµÄÏÂÁîÊÇʲô
ɾ³ý sql ±íµÄÏÂÁî
SQL ÖÐÓÃÓÚɾ³ý±íµÄÏÂÁîÊÇ DROP TABLE¡£
Óï·¨
DROP TABLE table_name;
µÇ¼ºó¸´ÖÆ
ÆäÖУ¬table_name ÊÇҪɾ³ýµÄ±íÃû¡£
Ó÷¨
Ҫɾ³ýÒ»¸ö±í£¬ÇëʹÓÃÒÔÏ°취£º
·¿ª SQL ÅÌÎʱà¼Æ÷¡£
ÊäÈë DROP TABLE ÏÂÁºó¸úҪɾ³ýµÄ±íÃû¡£
Ö´ÐиÃÏÂÁî¡£
ʾÀý
ÒÔÏÂÏÂÁîɾ³ýÃûΪ employees µÄ±í£º
DROP TABLE employees;
µÇ¼ºó¸´ÖÆ
×¢ÖØ
ɾ³ý±íÊÇÒ»¸ö²»¿ÉµõÏúµÄ²Ù×÷¡£É¾³ý±íºó£¬ÆäÖеÄËùÓÐÊý¾Ý¶¼½«ÓÀÊÀɥʧ¡£
ÔÚɾ³ý±í֮ǰ£¬ÇëÈ·±£Ã»ÓÐÈκÎÆäËû¹¤¾ß£¨ÈçÊÓͼ¡¢´æ´¢Àú³Ì»ò´¥·¢Æ÷£©ÒÀÀµ¸Ã±í¡£
ΪÁËÇå¾²Æð¼û£¬½¨ÒéÔÚɾ³ý±í֮ǰ½¨ÉèÒ»¸ö±íµÄ±¸·Ý¡£
ÒÔÉϾÍÊÇsqlÖÐɾ³ý±íµÄÏÂÁîÊÇʲôµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡
ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í×ðÁú¿Ê±¹ÙÍøµÇ¼ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ×ðÁú¿Ê±¹ÙÍøµÇ¼ʵʱÐÞÕý»òɾ³ý¡£