When using the schema update method AddColumn
it takes over attributes set for this property (like length etc) but the [Index]
attribute is not used - seems that I need to add CreateIndex
myself. Can this be changed?
The Modify Schema APIs should map to the expected SQL DDL commands that works across all databases, if we could create an index with the ADD ColumnName
statement in all RDBMS’s and be able to generate a reversible DROP Column statement we could do it, but its not standard SQL and very few RDBMS’s support it.