Displaying Procedure Parameter Information

Use sp_procparm to show information about stored procedure parameters.

In Interactive SQL, run sp_iqprocparm.
Display information about the parameters of the system procedure sp_iqshowcompression:
sp_iqprocparm sp_iqshowcompression, dbo, system

proc_name             proc_owner  parm_name    parm_type  parm_mode  
domain_name  width  scale  default

sp_iqshowcompression  dbo         @owner_name  normal     in  
char         128    0     (NULL)
sp_iqshowcompression  dbo         @table_name  normal     in  
char         128    0     (NULL)
sp_iqshowcompression  dbo         @column_name normal     in  
char         128    0     (NULL)
sp_iqshowcompression  dbo         Column       result     out  
char         128    0     (NULL)
sp_iqshowcompression  dbo         Compression  result     out  
char         3      0     (NULL)
Parent topic: Procedures