I have created a stored procedure that returns a table schema. There is one paramter passed in (the name of the table) and the SP returns the schema for that table:

Exec('Select * from ' + @TableName + ' FOR XML AUTO, XMLSCHEMA')

It appears that the "RetrievalProcedures" returns a data table. I will be getting back a long songle record (string).

Is the "RetrievalProcedures" the correct call for me to make to get the schema or is there is better suited method to use?

Thanks

It's impossible to determine how many rows are in the resultset, therefore the code can only assume there are more than 1 row, even if the row has a single value (as the # of columns is unknown too).

If you want to have a single value, consider using an output parameter.