用INFORMATION_SCHEMA获取包含某个字段的表

1. 为什么有的字段通过sys.columns攻取不到
2. 查看所有包含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'