[SQL Server] 프로시저의 모든 매개변수 한번에 보기

 

프로시저의 모든 매개변수 한번에 보기

 

SELECT 'Procedure_name' = b.name       , 'Parameter_name' = a.name       , 'Type' = type_name(user_type_id)       , 'Length' = max_length       , 'Prec' = CASE WHEN type_name(system_type_id)                            = 'uniqueidentifier'                  THEN precision                  ELSE OdbcPrec(system_type_id, max_length                              , precision) END       , 'Scale' = OdbcScale(system_type_id, scale)       , 'Param_order' = parameter_id    , 'Collation' = CONVERT(sysname                          , CASE WHEN system_type_id in                            (35, 99, 167, 175, 231, 239)                               THEN ServerProperty('collation') END)                                     FROM sys.all_parameters a join sys.objects b  ON a.object_id = b.object_id  WHERE b.type= 'p'