May 19th, 1999, 11:02 PM
sir,
When i drop a table having around 8000 records by executing SQL statement "DROP TABLE Tablename" ,then the execution fails.But if I drop a table having less records around 100 then the execution succeeds.Could you please tell me some other way to drop the table or tell me how to do it using the same statement. Actually I wanted to rename a table without using stored procedures ,so you please suggest me some way to do it .I was trying to it by first create another table with new name copy all the containts of the old table then drop the old table ,and while dropping the old table i am facing the problem.
When i drop a table having around 8000 records by executing SQL statement "DROP TABLE Tablename" ,then the execution fails.But if I drop a table having less records around 100 then the execution succeeds.Could you please tell me some other way to drop the table or tell me how to do it using the same statement. Actually I wanted to rename a table without using stored procedures ,so you please suggest me some way to do it .I was trying to it by first create another table with new name copy all the containts of the old table then drop the old table ,and while dropping the old table i am facing the problem.