9 lines
488 B
Transact-SQL
9 lines
488 B
Transact-SQL
--Migration
|
|
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE [name] = 'IX_TANITASIORA_OSZTALYCSOPORTID_TANTARGYID_INTEZMENYID_ORAKEZDETE_TANEVID_TANARID' AND [object_id] = OBJECT_ID('dbo.T_TANITASIORA')) BEGIN
|
|
CREATE INDEX IX_TANITASIORA_OSZTALYCSOPORTID_TANTARGYID_INTEZMENYID_ORAKEZDETE_TANEVID_TANARID
|
|
ON T_TANITASIORA (C_OSZTALYCSOPORTID, C_TANTARGYID, C_INTEZMENYID, C_ORAKEZDETE, C_TANEVID, C_TANARID)
|
|
INCLUDE (C_MEGTARTOTT, C_SORSZAMOZANDO)
|
|
WHERE TOROLT = 'F'
|
|
END
|
|
GO
|