MSSQL user_source(oracle)
DB/MSSQL
2019. 6. 24. 11:11
반응형
-- 프로시저및 테이블 확인
select * from sys.sysobjects where type = 'U'; -- talbe list
select * from sys.sysobjects where type = 'P'; -- PROCEDURE list
select name from sys.sysobjects -- 프로시저내 문자열
where id in ( select DISTINCT id from sys.syscomments where UPPER(text) like '%JAVA%' )
반응형