DJ메탈짱™의 Free Style

특정컬럼에 해당되는 테이블명, 컬럼명, 컬럼타입 조회 SELECT obj.name, col.name, tp.nameFROM sysobjects obj, syscolumns col, systypes tpWHERE obj.id = col.id AND obj.xtype = 'U' and col.xtype = tp.xtypeand col.name like '%owner%'ORDER BY 1

-- 데이터베이스에 존재하는 모든 프로시저에서 사용된 테이블, 함수를 추출한다.WITH sp_list AS ( SELECT o.name AS proc_name , oo.name AS table_name , Row_number() OVER(partition by o.name, oo.name ORDER BY o.name, oo.name) AS row FROM sysdepends d INNER JOIN sysobjects o ON o.id = d.id INNER JOIN sysobjects oo ON oo.id = d.depid WHERE o.xtype = 'P')SELECT proc_name, table_nameFROM sp_list aWHERE row = 1 ORDER BY proc_name, table_..

SELECT obj.name, col.name FROM sysobjects obj, syscolumns col WHERE obj.id = col.id AND obj.xtype = 'u' AND obj.status > 0 AND col.name LIKE '%Fee_id%' ORDER BY 1

SELECT S.NAME, c.Text FROM SYSOBJECTS S, SYSCOMMENTS C WHERE S.ID = C.ID AND C.TEXT LIKE '%보현%' ORDER BY S.NAME