获取所有表名
select table_name,table_type from information_schema.tables where
table_schema='asdb' and table_type='base table';
获取视图名
select table_name from information_schema.views where
select table_name,table_type from information_schema.tables where
table_schema='asdb' and table_type='base table';
获取视图名
select table_name from information_schema.views where
table_schema='asdb'
获取所有表名和视图名
select table_name,table_type from information_schema.tables where
table_schema='asdb'
获取所有表名
select table_name,table_type from information_schema.tables where
table_schema='asdb' and table_type='base table';
获取视图名
select table_name from information_schema.views where
table_schema='asdb'
获取所有表名和视图名
select table_name,table_type from information_schema.tables where
table_schema='asdb'