用sql获取数据库中所有的表名的方法: 1、oracle下:select table_name from all_tables; 2、MySQL下:select table_name from information_schema.tables where table_schema='csdb' and table_type='base table'; 3、sql server下:select name from sys.tables go本回答被网友采纳
第3个回答 2018-05-23
sqlserver:
USE db_name SELECT name FROM sysobjects WHERE xtype='U' GO
mysql:
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='db_name'