- 为什么有的字段通过sys.columns攻取不到
- 查看所有包含partitioon的表
SELECT t.*,c.COLUMN_NAME FROM INFORMATION_SCHEMA.[COLUMNS] AS c INNER JOIN
INFORMATION_SCHEMA.TABLES
AS t ON t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME
AND t.TABLE_CATALOG = c.TABLE_CATALOG WHERE t.TABLE_TYPE = 'BASE TABLE'
AND c.COLUMN_NAME = 'partition'