查詢所有含有active 字段的log表

查詢所有含有active 字段的log表

＝＝＝

select table_name   from information_schema.COLUMNS
where COLUMN_NAME='active'
and TABLE_CATALOG =(select TABLE_CATALOG from csps_system_param where pname='TABLE_CATALOG')
and table_name like 'log%'