SQL语句杂记

--查询包含指定列名'IMG_CLS'的表sqlserver
SELECT OBJECT_NAME(object_id) as '表名',name as '列名' from sys.columns where name ='IMG_CLS' --or name ='IMG_FMT' order by OBJECT_NAME(object_id);

--解锁被锁的表格orcle

select b.owner,b.object_name,a.session_id,c.serial#,a.locked_mode from v$locked_object a,dba_objects b，v$session c  where b.object_id = a.object_id and a.session_id = c.sid;
alter system kill session'session_id,serial#';