Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
You could open the DBC with USE MyDBC.DBC, locate the record about the missing table and delete it.
To copy one table to another:
USE OriginalTable
COPY TO DestTable DATABASE OtherDBC WITH CDX
Note that not all properties will be transferred. The PK, if any, will now be a candidate key and some properties, like Default Value, will be lost.
>I some how messed up with deleting a table and now the database is looking for it and says it does not exist (well, I know that :). I can not "clear" out the missing table in that database. Worst is I can not "COPY STRUCTURE TO abc DATABASE db1". I am willing to start over (it is a 4 tables project). How to fix this table thing or should I start over (can I copy the stru to freetable and then add it into a database afterwards?).
>
>I created a new database (db2) and seems I dont know how to copy database table(s) to another database???
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