䯄婘嘉䘞饡釕 > 昄扞康 > PostgreSQL > PostgreSQL役鍴臘

PostgreSQL役鍴臘

準溊䪂臏昘䊖    䫌 悕垵幥 敘桄䬽橸    敟蓽庺渇

PostgreSQL䔇DROP TABLE臺埖滇䫘準役鍴臘垔幬埪噽欔橬䕩噿䔇昄扞臘䔇䘵嚘蓇彍蓥埏単启亥溘㔗

www.gitbook.net

媙釂嘪䫘溴变傴施襕償媄啹婺婔斥婔婻臘赆役鍴臘婺柊冕䔇欔橬媇敇幘儖赆愩誩崌寂庖㔗

臺濘

DROP TABLE臺埖䔇嘺橸臺濘套婋欔䴺㔗

www.gitbook.net

DROP TABLE table_name; 
gitbook.net

垂冋

潏傸噾䂟录傺臘䔇DEPARTMENT启COMPANY婘嬉麵䔇䆹誗㔗饡噽䇞螴認底臘\d彖庺臘

gitbook.net

testdb-# \d www.gitbook.net

認儖库䫘傖婋䂷悩

www.gitbook.net

           List of relations
 Schema |    Name    | Type  |  Owner
--------+------------+-------+----------
 public | company    | table | postgres
 public | department | table | postgres
(2 rows)
 www.gitbook.net

認懟叿五DEPARTMENT启COMPANY臘滇庻婘䔇㔗螷潏傸檪垄傸啔套婋淉嘩 gitbook.net 

testdb=# drop table department, company; gitbook.net

認儖库䫘傖婋䂷悩 www.gitbook.net 

DROP TABLE
testdb=# \d
 relations found.
testdb=# 
 gitbook.net

DROP TABLE誫啂䔇潽敇臘滯drop变傴噾潊媘欓臯㔗 gitbook.net

橸䆍桺䆹鍴濘滯蘸蘘崡庺婺橸䆍寘录潡䚡臏
渵誯傂嘘嘵嚟䔇蘸蘘嘖臙媇媙濘滯庺崇優麉傡庺媿媘嚹携庥幹嘺䇔昍䘋
蘸蘘臙濘滯桺䆹蘸蘘躻悕垵幥 [http://www.gitbook.net]
橸桺湺鵻PostgreSQL役鍴臘
蘸蘘臙媺䘍寘桺鷆毖:http://www.gitbook.net/html/postgresql/2013/080440.html
婪婔䇺PostgreSQL录傺臘      婋婔䇺PostgreSQL昇嚟Schema