查詢所有含有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%'