Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement