When user generates DDLs of SQL Server tables with a CLUSTERED primary keys, Toad leaves out keyword CLUSTERED in DDL statement to alter the table when adding primary key. Model was created by reverse engineering a SQL Server 2008 R2 database.
As default all SQL Server primary keys are created as clustered keys so including the keyword CLUSTERED is not necessary.
Note: There is Clustered check box in General tab of Key Properties window where it can be checked off and then the word UNCLUSTERED will be included in the script.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center