Re: Anyone writing stored procs

Try this select procname from sysprocedures where procname='procname' or for tables select tabname from systables where tabname='table name' This should do what you are asking. Good Luck. -- Joseph Cullipher |E-mail: joseph@cannonexpress.com PO Box 364 |opinions express are those of my own and Springdale, AR 72764 USA |don't necessarily reflect those of my company On 12 Nov 1996, Brian Weedman wrote: > How do you know if your proc exists in informix so you can drop it > before trying to re-restore it. In SqlServer you can do this > > If (Exists (Select * from sysobjects where name = 'procname' and type = 'P')) > Drop proc procname > go > > I would like to do this for tables too. > > sqlserver syntax: > If (Exists (Select * from sysobjects where name = 'tablename' and type = 'U')) > Drop table tablename> > > Is there anything like it in informix? Or is there a way to get > the informix sql editor to continue on even if theres an error. >