Thanks for answering back Mark. When do the following code I generate a random table that ends up in my employee.dbc:

SELECT Employee.e_cto, Employee.e_dtetemp, Employee.e_ssn,; && previous image to alter
Employee.e_fname, Employee.e_lname, Employee.e_id;
FROM employee!employee;
into table (ranvar) database employee ;
WHERE Employee.e_empstatus = 4;
ORDER BY Employee.e_lname

after this is issue the following command to remove the table from dbc:

ranvar = .ranvar
drop table (ranvar)

The drop table removes the table from my harddrive, but I can still the table name in my project manager under database dbc. If I double click on this it asks me to locate the table or delete it. The table doesn't even exist and I was wondering how do I delete it completely or cleanly from dbc, even though it doesn't exist?


Thanks again
Nick Patel