Sparx Systems Forum
Enterprise Architect => Suggestions and Requests => Topic started by: Gnurik on March 24, 2004, 08:54:19 am
-
Hi,
When generating DDL scripts, Clustered Indexes are written out after Primary Key Constraints. Since Primary Key Constraints cannot be given a "Nonclustered" property in EA and are assumed to be Clustered in MS SQL 2k (unless there is already another clustered index on the table), when the script gets to creating the Clustered indexes, it complains, saying that there already is one on the table.
I would like to write out the clustered indexes before the primary key constraints, and in this case, the primary keys can be created non-clustered implicitly.
I hope this makes sense,
Thanks in advance,
Gennady