Support Forums - View Thread

View Thread

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

Messages 1 to 3 of 3 total

Wed, Jan 3 2007 8:42 AM	Permanent Link
Robert Smith	I cannot see any way to create an index when creating a table, only by altering it after creation. It would be nice to include an Index tab during creation...
Wed, Jan 3 2007 3:20 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Robert, << I cannot see any way to create an index when creating a table, only by altering it after creation. >> Tables and indexes are not one and the same like they were with DBISAM. Tables and constraints are. Indexes are simply an additional sorting and performance enhancement, so they are handled separately from table definitions. This is keeping in line with the SQL standard. -- Tim Young Elevate Software www.elevatesoft.com
Wed, Jan 3 2007 10:26 PM	Permanent Link
Robert Smith	Ok, thanks... "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Robert, Tables and indexes are not one and the same like they were with DBISAM. Tables and constraints are. Indexes are simply an additional sorting and performance enhancement, so they are handled separately from table definitions. This is keeping in line with the SQL standard. -- Tim Young Elevate Software www.elevatesoft.com