10 lines
287 B
Transact-SQL
10 lines
287 B
Transact-SQL
USE [EnVisage]
|
|
GO
|
|
|
|
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'IX_PeopleResourceAllocation_PeopleResourceId')
|
|
BEGIN
|
|
CREATE NONCLUSTERED INDEX IX_PeopleResourceAllocation_PeopleResourceId
|
|
ON [dbo].[PeopleResourceAllocation] ([PeopleResourceId])
|
|
INCLUDE ([ScenarioId])
|
|
END
|
|
GO |