SQLServer查表查字段

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