Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

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