Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
EDB 2.5 - Can i to create a new table from existing table ? |
Mon, Jan 31 2011 9:05 AM | Permanent Link |
Mauro Botta | Hi
With EDB 2.05 can i to create a new table from existing table in SQL mode ? like this SQL: CREATE TABLE LIKE MYOLDTABLE structure,index,constraits,default field..... but not data, only 100 % structure Mauro Botta. TECNOS |
Mon, Jan 31 2011 9:44 AM | Permanent Link |
Mauro Botta | EDB 2.05 ...ops
|
Mon, Jan 31 2011 12:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mauro,
<< With EDB 2.05 can i to create a new table from existing table in SQL mode ? like this SQL: CREATE TABLE LIKE MYOLDTABLE structure,index,constraits,default field..... but not data, only 100 % structure >> Yes, you can do so, but constraints, indexes, and triggers are not copied over. Adding the other table properties has been on the list for some time, so I'll see if I can squeeze it in the next build. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 1 2011 4:56 AM | Permanent Link |
Mauro Botta | Thank You Tim
|
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |