Add option to check if object exists when creating stored procedure
It would be helpful if you would add an option to check if the objects used in a stored procedure really exist when creating it.
Example:
CREATE OR ALTER PROCEDURE [dbo] [SelectFromTableThatDoesNotExist].
AS
BEGIN
SELECT * FROM [dbo] [NonExistingTable];
END
The table used in the procedure does not exist, but the procedure can be created without errors. In this case, it would be desirable if SQL Prompt had an option to output an error when creating the procedure.
3
votes
Christian
shared this idea