If i have a hypthetical index on my database:Create index IdxName on TableName(ColumnName) with statistics_onlyFirstly SSDT doesnt understand the syntax so i have to create it as non hypothetical.Then when i publish to the database SSDT will generate the the create statement as if no index exists, causing an "INDEX ALREADY EXISTS" error when executed.
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization