How to query field names of a stored procedure?

• blast2hell

  Right there with Babe

  Points: 771

  More actions

  April 11, 2008 at 9:32 am

  #185317

  Ok, so I want to get all the field names of a given procedure. So far I've found

  Select * from Information_Schema.Routines where Routine_Name = 'some_procedure'

  but that just gets me a list of all the procedures....which is good...but I need to go one step further and get the fields in that procedure....possible?

• John Beggs

  SSCommitted

  Points: 1921

  More actions

  April 11, 2008 at 11:08 am

  #801640

  Take a look at sp_sproc_columns and sp_sproc_columns_90 (Assuming SQL 2K5).

  GL!