What about Copy To <fullpath>\<tablename> Database Moo Set Database To Quack Drop Table <tablename> ?
On Thu, Oct 8, 2009 at 11:56 PM, Vince Teachout <[email protected]> wrote: > Paul McNett wrote: >> Vince Teachout wrote: >>> Assume empty database Moo, and database Quack with one table. >>> The one table has a long filename, table comments, and some data. >>> >>> Is there a simple way to move the table from Quack to Moo, without >>> losing any of the extended table attributes? >>> >>> The "obvious" method of dragging the table from one Database to another >>> in developer mode doesn't work. >>> >>> Any ideas? Thanks! >> >> It is messy, because the database has plenty of references to the table, and >> the >> table has a backreference to the database name. > > I was kind of afraid of that. I might also try something like using > gendbc to generate the code for the tables and dbc, then modifying the > code to a new dbc name and appending it. I was just hopeing I was > missing something simple. Thanks. > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
