Re: [SQL] Stored procedures and relations

On Fri, 28 Nov 2003, FET wrote: > Hi everybody, > I have a stored procedure that drops table A and then creates table A > again. The table A has no constraints on any columns. When I execute > the stored procedure by saying: SELECT sp_myproc(); It gives me an > error saying : Relation 68428 does

[SQL] Stored procedures and relations

Hi everybody, I have a stored procedure that drops table A and then creates table A again. The table A has no constraints on any columns. When I execute the stored procedure by saying: SELECT sp_myproc(); It gives me an error saying : Relation 68428 does not exist. When I remove the CREATE FUNCTIO