>I am trying to copy a table from one DBC to another DBC. The table has a default value on the Primary Key of NEWKEY('mytable'). When I do the copy: COPY TO tablename DATABASE newdb WITH PRODUCTION I thought that would do it. Am I going to have to recreate the DEFAULT after I copy the table, or is their a better way?
YOur NewKey routine is not a part of your table, it is part of the dbc, and so does not go with the table. You will have to recreate the routine in the new database. There are ways you can do this programmatically, but they are not easier than cut and paste...
Erik Moore
Clientelligence