Generating Indexes

[WellerEE]

Hi,

I would like a way to indicate that an index/key is being created with the CLUSTERED attribute.  I also need a way to set the ROWGUIDCOL property.  

Thanks in advance,
Ed

[sparks]

Hello,

To define an index as 'Clustered' bring up the operations window, select the index operation in question and then click on the 'Extended Properties' button.  This will allow you to define the index as Clustered, Unique and Ascending or Descending.

At the moment their is no way to define a column as a ROWGUIDCOL, however we have made a note of your request and try and include it into EA ASAP.

Paul Mathers

[WellerEE]

When I click the extended properties button, I don't get anything. No WIndow No Nothing?