SQLServer查表查字段
//查询表名
select * from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE';
//查询字段名
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Dim_Discount';
//查询表名
select * from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE';
//查询字段名
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Dim_Discount';