devxlogo

Check for the Existence of a Stored Procedure Using T-SQL

Check for the Existence of a Stored Procedure Using T-SQL

To check for the existence of a stored procedure, select the name from sysobjects where name=’mystoredprocedure’ and xtype=’p’.

devx-admin

Share the Post: