Page 1 of 1

About copy tables

PostPosted: Fri Jan 23, 2009 5:42 pm
by carlos torres
Hi NB Team

It will be nice to have an action command within dbPro that let you copy/export tables, copy/export just the structure or structure plus data.

It will save a lot of time when you have to manipulate a lot of tables.

regards

carlost

PostPosted: Sat Jan 24, 2009 5:02 pm
by Neosoft Support
I think you can accomplish these things with SQL.

Copy table with data:

CREATE TABLE NewTable SELECT * FROM OldTable

Copy table structure only (no data):

SELECT * INTO NewTable FROM OldTable WHERE 1=0