General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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???
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only