Exit from a store proc if table or another storeproc not exist

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  November 27, 2005 at 11:42 am

  #166692

  Hi guys,

  how can i verify if a table or store proc exist and if not exist exit the procedure.

  I tried with:

  if object_id(tablename) is  null

  begin

  return  (-1)

  end

  but SQL give an error :

  A RETURN statement with a return value cannot be used in this context,

  theb same with:

  IF EXISTS(select....sysobject...type = 'U')

  .....

   

  Any idea how to exit from a store proc if a table does not exit.

  I thought :

  select....sysobject...type = 'U'

  if @@rowcount = 0

  RETURN

  Another way ...?

   

  Any help will be very appreciated.

  

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  November 27, 2005 at 3:01 pm

  #605994

  Declare @ObjectExists bit

  IF object_id(tablename) is  null

  SET @ObjectExists = 0

  ELSE

  SET @ObjectExists = 1

  .....

  _____________
  Code for TallyGenerator