Viewing post 1 (of 2 total)
Why not simply:Create Index IndexName on schema.tablename (columnlist)with (drop_existing = on);
Why not simply:
Create Index IndexName on schema.tablename (columnlist)
with (drop_existing = on);
[/quote]
Because sometime you may want to create an index only if it does not exist. The with drop_existing is...
March 6, 2014 at 9:57 am
#1694789