Query

Hi,

In a Stored Procedure i have written the following code.

DROP TABLE GAHP.T2 ;

COMMIT;

CREATE TABLE GAHP.T2 (STATENAME VARCHAR(25) , COUNTIES VARCHAR(30) , PARTIALCOUNTIES VARCHAR(30) ,
LIMITEDSERVICES VARCHAR(30) , CITIES VARCHAR(30) , PARISHES VARCHAR(30) , PARTIALPARISHES VARCHAR(30),
BOROUGHS VARCHAR(30)) ;


But when i build it get the following error message.

The name of the object to be created is identical to the existing name "GAHP.T2" of type "TABLE". LINE NUMBER=24. SQLSTATE=42710

Could anyone tell me why the table it not getting dropped ?
I have the access rights to drop a table.

Thanks,
Amrita

1) Please use an appropriate subject title in the future. Yours is inadequate.

2) Why are you trying to drop and recreate the table like this? It would appear that the table has a static definition, so instead of dropping it and recreating it, why not just delete the contents of the table?