2009. 11. 16. 23:34
MSSQL
-- Function 및 Procedure 등의 파라미터 정보를 가져온다.
select * from INFORMATION_SCHEMA.PARAMETERS
-- Procedure정보와 파라미터 정보 추출
Select
A.specific_catalog, A.Specific_Name, A.routine_type,
B.ordinal_position, B.parameter_name, B.data_type, B.character_maximum_length,
A.routine_definition
From INFORMATION_SCHEMA.ROUTINES A
Inner Join INFORMATION_SCHEMA.PARAMETERS B On A.specific_catalog=B.specific_catalog and A.Specific_Name=B.Specific_Name
Where A.routine_type='PROCEDURE'
Order By ROUTINE_TYPE, ROUTINE_NAME
select * from INFORMATION_SCHEMA.PARAMETERS
-- Procedure정보와 파라미터 정보 추출
Select
A.specific_catalog, A.Specific_Name, A.routine_type,
B.ordinal_position, B.parameter_name, B.data_type, B.character_maximum_length,
A.routine_definition
From INFORMATION_SCHEMA.ROUTINES A
Inner Join INFORMATION_SCHEMA.PARAMETERS B On A.specific_catalog=B.specific_catalog and A.Specific_Name=B.Specific_Name
Where A.routine_type='PROCEDURE'
Order By ROUTINE_TYPE, ROUTINE_NAME