I have an index in a table that looks like this.
CREATE NONCLUSTERED INDEX [idx_RouteAssignment_Dashboard] ON [dbo].[RouteAssignments]
INCLUDE ( [RouteId]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
This configuration will create index, but I can find no way to include the [RouteId] as an INCLUDE.
If I was to update the schema Data ACcess will delet my current index and put in the on without the INCLUDE. How do I incorporate the Include or fix the Update DDL?