如何用sql获取数据库中所有表名
1、双击打开MySQL软件，在左侧中找到【表】并且右击选择【新建表】，
2、选择新建表之后，在界面右侧可以添加数据，点击【添加栏目】就可以在下方再添加一行数据，
3、点击【另存为】，会弹出一个【表名】窗口，输入表名，比如Class，点击【确定】按钮，
4、在表的下方就会出现一个名为Class的表了
绛旓細1銆侀氳繃鍛戒护琛屾煡璇 \d 鏁版嵁搴 鈥斺 寰楀埌鎵鏈夎〃鐨勫悕瀛 \d 琛ㄥ悕 鈥斺 寰楀埌琛ㄧ粨鏋 2銆閫氳繃SQL璇彞鏌ヨ "select * from pg_tables" 鈥斺 寰楀埌褰撳墠db涓墍鏈夎〃鐨勪俊鎭紙杩欓噷pg_tables鏄郴缁熻鍥撅級"select tablename from pg_tables where schemaname='public'" 鈥斺 寰楀埌鎵鏈夌敤鎴疯嚜瀹氫箟琛ㄧ殑鍚嶅瓧锛堣繖閲...
绛旓細鏄竴绉鏁版嵁搴鏌ヨ鍜岀▼搴忚璁¤瑷锛岀敤浜庡瓨鍙栨暟鎹互鍙婃煡璇佹洿鏂板拰绠＄悊鍏崇郴鏁版嵁搴撶郴缁燂紱鍚屾椂涔熸槸鏁版嵁搴撹剼鏈枃浠剁殑鎵╁睍鍚嶃SQL璇彞鏃犺鏄绫昏繕鏄暟閲忛兘鏄箒澶氱殑锛屽緢澶氳鍙ヤ篃鏄粡甯歌鐢ㄥ埌鐨勶紝SQL鏌ヨ璇彞灏辨槸涓涓吀鍨嬬殑渚嬪瓙锛屾棤璁烘槸楂樼骇鏌ヨ杩樻槸浣庣骇鏌ヨ锛孲QL鏌ヨ璇彞鐨勯渶姹傛槸鏈棰戠箒鐨勩
绛旓細鐢╯ql鑾峰彇鏁版嵁搴撲腑鎵鏈鐨琛鍚嶇殑鏂规硶锛1銆乷racle涓嬶細select table_name from all_tables;2銆丮ySQL涓嬶細select table_name from information_schema.tables where table_schema='csdb' and table_type='base table';3銆乻ql server涓嬶細select name from sys.tables go ...
绛旓細鐢ㄦ暟鎹瓧鍏 select from dba_users;鏌ョ湅鏁版嵁搴閲岄潰鎵鏈夌敤鎴凤紝鍓嶆彁鏄綘鏄湁dba鏉冮檺鐨勫笎鍙凤紝濡俿ys,system select from all_users;鏌ョ湅浣犺兘绠＄悊鐨勬墍鏈鐢ㄦ埛锛乻elect from user_users;鏌ョ湅褰撳墠鐢ㄦ埛淇℃伅 锛
绛旓細鐩存帴閫氳繃sysobjects琛ㄨ繘琛屾煡璇㈠嵆鍙sql锛歋ELECT NAME FROM sysobjects t WHERE t.xtype='U';瑙ｉ噴锛氫互涓婅鍙ュ氨鍙互瀹炵幇鏌愪釜鏁版嵁搴撹〃鐨鏌ヨ浜嗭紝濡傛灉鏄兂鏌ヨ鎵鏈淇℃伅锛屽皢name鏇挎崲涓衡*鈥濆嵆鍙
绛旓細1銆侀鍏堝湪鐢佃剳涓墦寮Microsoft SQL Server锛屾煡璇㈡墍鏈夋暟鎹簱銆2銆佹煡璇㈠綋鍓鏁版嵁搴撲腑鎵鏈夎〃鍚嶃傝鏄庯細xtype='U':琛ㄧず鎵鏈夌敤鎴疯〃锛寈type='S':琛ㄧず鎵鏈夌郴缁熻〃銆3銆佹煡璇㈡寚瀹琛ㄤ腑鐨勬墍鏈夊瓧娈靛悕銆4銆佺劧鍚庢煡璇㈡寚瀹氳〃涓紝鎵鏈夊瓧娈靛悕鍜屽瓧娈电被鍨嬨5銆佹帴鐫鑾峰彇涓婚敭瀛楁锛鑾峰彇鏁版嵁搴鎵鏈夌被鍨嬶紝灏卞畬鎴愪簡銆
绛旓細MS SQL 濡備綍妫瑙嗕竴涓鏁版嵁搴撲腑鎵鏈夎〃鐨勮鏁 [鎽樿]鏈枃浠嬬粛閫氳繃鏌ヨ绯荤粺琛╯ysobjects鍜宻ysindexes瀹炵幇MS SQL 妫瑙嗕竴涓暟鎹簱涓墍鏈夎〃鐨勮鏁帮紝骞舵彁渚涚畝鍗曠殑绀轰緥绋嬪紡鐮佷緵鍙傝冦--璇诲彇搴撲腑鐨勬墍鏈夎〃鍚 select name from sysobjects where xtype='u' --璇诲彇鎸囧畾琛ㄧ殑鎵鏈夊垪鍚 select name from ...
绛旓細1銆佹墦寮plsql锛岃緭鍏ョ敤鎴枫佸瘑鐮併鏁版嵁搴鍚嶇瓑锛岃繘琛岀櫥褰曪紝2銆佺櫥褰曡繘plsql鍚庯紝鐐瑰嚮鏂板缓->SQL绐楀彛锛3銆佸湪鏂板缓鐨剆ql绐楀彛涓紝缂栧啓sql璇彞锛宻elect * from all_tables t;鏌ョ湅鎵鏈夎〃锛4銆佹墽琛岃鍙elect owner, count(*) from all_tables group by owner锛屾煡鐪嬫瘡涓敤鎴蜂笅鎵鏈夎〃鐨鏁伴噺锛...
绛旓細SQL鏁版嵁搴擄紝鏌ヨ鍖呭惈鍒楋紙瀛楁锛屽鍚嶇О锛夌殑鏁版嵁搴撲腑鐨勬墍鏈夎〃鐨勬楠ゅ涓嬶細闇瑕佸噯澶囩殑鏉愭枡鏄細璁＄畻鏈猴紝sql finder銆1锛岄鍏堬紝鎵撳紑sql鏌ヨ鍣ㄥ苟杩炴帴鍒扮浉搴旂殑鏁版嵁杩炴帴锛屼緥濡傛祴璇曞簱銆2锛屽崟鍑烩滄煡璇⑩濇寜閽苟閿叆锛歴elect table_name鏉ヨ嚜information_schema.columns锛屽叾涓璽able_schema =鈥渢est鈥濆拰column_name =鈥...
绛旓細SQL>select table_name from user_tables;绫讳技鐨勶紝浣犲彲浠ヨ繘琛屾浛鎹:)濡傛灉浣犳兂鏌鏁版嵁搴撲腑鎵鏈鐨琛鐨勮瘽锛屽彲浠ユ煡璇 SELECT * FROM dba_tables 濡傛灉浣犳兂鏌ヨ鏁版嵁搴撲腑鏌愪釜鐢ㄦ埛涓嬬殑琛ㄧ殑璇濓紝涔熷彲浠ョ櫥褰曡繖涓敤鎴凤紝鍐嶆煡璇細SELECT * FROM USER_TABLES 瑕佹兂瀵煎叆澶栭儴sql璇彞鍙互鐢ㄥ懡浠 sql >@e:\鏂囦欢鍚.sql...
