MS SQL.System Table-Procedure 목록보기

[ MS SQL.System Table-Procedure 목록보기 ]

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_CATALOG = 'TUSA_A' AND SPECIFIC_NAME LIKE 'USP_USA_SO%' ;

 

 

select * from sys.objects;

 

 

Select ROUTINE_NAME
From INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_TYPE='PROCEDURE' Order By ROUTINE_NAME