View Issue Details

IDProjectCategoryView StatusLast Update
0004373SymmetricDSImprovementpublic2020-04-27 14:38
ReporterpmarzulloAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.11.8 
Target VersionFixed in Version 
Summary0004373: SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils
DescriptionCREATE INDEX FIBillOfMaterialsWithEndDate
    ON Production.BillOfMaterials (ComponentID, StartDate)
    WHERE EndDate IS NOT NULL ;

Notice the WHERE clause in the creation of the index.

Need to change database.dtd, adding a new attribute to index and unique sections. New attribute could be "filter".
Need to add support to DDL Reader to read filter specification for SQL Server Reader, all others should default to not supporting it.
Export to XML should add this attribute to indexes when specified.
DDL Writer needs to support this new attribute.
Tagsddl/schema, dialect: sql-server

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-04-27 14:38 pmarzullo New Issue
2020-04-27 14:38 pmarzullo Tag Attached: ddl/schema
2020-04-27 14:38 pmarzullo Tag Attached: dialect: sql-server