SQL Server Management Studio: how to parse stored procedure code and check if table columns exist? I'm afraid that SSMS won't parse table columns within a stored procedure.

When you click in Parse option



SSMS says that parse is completed, even when a procedure is selecting a column that does not exists in a table.

When you run your script, SSMS shows what the Parse should warn about:



Is there a way to parse a script in order to check if table fields really exist before creating or altering procedures?
I don't think there's any way to do this with a parse, but you could try running the script inside a transaction then rolling back that transaction at the end. If there's an error, it should throw it, but even if there isn't, there won't be any lasting changes.