这些信息可从以下
INFORMATION_SCHEMA视图获得：
SELECt * FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAGE AS cuJOIN INFORMATION_SCHEMA.COLUMNS AS cON c.TABLE_SCHEMA = cu.TABLE_SCHEMAAND c.TABLE_CATALOG = cu.TABLE_CATALOGAND c.TABLE_NAME = cu.TABLE_NAMEAND c.COLUMN_NAME = cu.COLUMN_NAMEWHERe cu.VIEW_NAME = '<your view name>'AND cu.VIEW_SCHEMA = '<your view schema>'
如果您的视图包含来自多个数据库的表，则查询将变得更加复杂
