用sql获取数据库中所有的表名、字段名

 https://blog.csdn.net/wyf2017/article/details/78824998

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

 https://jingyan.baidu.com/article/fea4511aab5ff1b7bb912598.html

SELECT name FROM syscolumns  where id=object_id('dbo.Table_1')