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
Source language:
-
English
- English
- French
- German
- Spanish
- Italian
- Russian
-
English
- English
- French
- German
- Spanish
- Italian
- Russian
- Arabic
- Bulgarian
- Chinese
- Croatian
- Czech
- Danish
- Dutch
- Greek
- Hebrew
- Japanese
- Korean
- Latvian
- Lithuanian
- Norwegian
- Polish
- Portuguese
- Romanian
- Serbian
- Slovak
- Slovenian
- Swedish
- Ukrainian
About copy tables
Moderator: Neosoft Support
2 posts
• Page 1 of 1
About copy tables
by carlos torres » Fri Jan 23, 2009 5:42 pm
-
carlos torres - Posts: 289
- Joined: Mon May 02, 2005 8:14 am
- Location: Pamplona, Colombia
by Neosoft Support » Sat Jan 24, 2009 5:02 pm
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
Copy table with data:
CREATE TABLE NewTable SELECT * FROM OldTable
Copy table structure only (no data):
SELECT * INTO NewTable FROM OldTable WHERE 1=0
NeoSoft Support
- Neosoft Support
- NeoSoft Team
- Posts: 5593
- Joined: Thu Mar 31, 2005 10:48 pm
- Location: Oregon, USA
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: Bing [Bot], Yahoo [Bot] and 2 guests