CREATE INDEX_v2.txt
| 1 |
IF(EXISTS(SELECT * |
|---|---|
| 2 |
FROM sys.indexes |
| 3 |
WHERE name='IX01_PL_REQUEST_DOC' AND object_id = OBJECT_ID('PL_REQUEST_DOC')))
|
| 4 |
BEGIN |
| 5 |
DROP INDEX IX01_PL_REQUEST_DOC ON PL_REQUEST_DOC |
| 6 |
END |
| 7 |
ELSE |
| 8 |
BEGIN |
| 9 |
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_DOC] ON [dbo].[PL_REQUEST_DOC] ([REQ_ID]) |
| 10 |
END |
| 11 |
|
| 12 |
IF(EXISTS(SELECT * |
| 13 |
FROM sys.indexes |
| 14 |
WHERE name='IX01_PL_REQUEST_DOC_DT' AND object_id = OBJECT_ID('PL_REQUEST_DOC_DT')))
|
| 15 |
BEGIN |
| 16 |
DROP INDEX IX01_PL_REQUEST_DOC_DT ON PL_REQUEST_DOC_DT |
| 17 |
END |
| 18 |
ELSE |
| 19 |
BEGIN |
| 20 |
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_DOC_DT] ON [dbo].[PL_REQUEST_DOC_DT] ([REQ_ID]) |
| 21 |
END |
| 22 |
|
| 23 |
IF(EXISTS(SELECT * |
| 24 |
FROM sys.indexes |
| 25 |
WHERE name='IDX_PL_REQUEST_PROCESS_PROCESS_ID' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS')))
|
| 26 |
BEGIN |
| 27 |
DROP INDEX IDX_PL_REQUEST_PROCESS_PROCESS_ID ON PL_REQUEST_PROCESS |
| 28 |
END |
| 29 |
ELSE |
| 30 |
BEGIN |
| 31 |
CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_PROCESS_ID] ON [dbo].[PL_REQUEST_PROCESS] ([REQ_ID]) |
| 32 |
END |
| 33 |
|
| 34 |
IF(EXISTS(SELECT * |
| 35 |
FROM sys.indexes |
| 36 |
WHERE name='IX01_PL_REQUEST_PROCESS' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS')))
|
| 37 |
BEGIN |
| 38 |
DROP INDEX IX01_PL_REQUEST_PROCESS ON PL_REQUEST_PROCESS |
| 39 |
END |
| 40 |
ELSE |
| 41 |
BEGIN |
| 42 |
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS] ON [dbo].[PL_REQUEST_PROCESS] ([REQ_ID]) |
| 43 |
END |
| 44 |
|
| 45 |
IF(EXISTS(SELECT * |
| 46 |
FROM sys.indexes |
| 47 |
WHERE name='IX01_PL_REQUEST_PROCESS_CHILD' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS_CHILD')))
|
| 48 |
BEGIN |
| 49 |
DROP INDEX IX01_PL_REQUEST_PROCESS_CHILD ON PL_REQUEST_PROCESS_CHILD |
| 50 |
END |
| 51 |
ELSE |
| 52 |
BEGIN |
| 53 |
CREATE NONCLUSTERED INDEX [IX01_PL_REQUEST_PROCESS_CHILD] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([PROCESS_ID]) |
| 54 |
END |
| 55 |
|
| 56 |
IF(EXISTS(SELECT * |
| 57 |
FROM sys.indexes |
| 58 |
WHERE name='IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID' AND object_id = OBJECT_ID('PL_REQUEST_PROCESS_CHILD')))
|
| 59 |
BEGIN |
| 60 |
DROP INDEX IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID ON PL_REQUEST_PROCESS_CHILD |
| 61 |
END |
| 62 |
ELSE |
| 63 |
BEGIN |
| 64 |
CREATE NONCLUSTERED INDEX [IDX_PL_REQUEST_PROCESS_CHILD_REQ_ID] ON [dbo].[PL_REQUEST_PROCESS_CHILD] ([REQ_ID]) |
| 65 |
END |
| 66 |
|
| 67 |
IF(EXISTS(SELECT * |
| 68 |
FROM sys.indexes |
| 69 |
WHERE name='IDX_TL_USER_TLNANME' AND object_id = OBJECT_ID('TL_USER')))
|
| 70 |
BEGIN |
| 71 |
DROP INDEX IDX_TL_USER_TLNANME ON TL_USER |
| 72 |
END |
| 73 |
ELSE |
| 74 |
BEGIN |
| 75 |
CREATE NONCLUSTERED INDEX [IDX_TL_USER_TLNANME] ON [dbo].[TL_USER] ([TLNANME]) |
| 76 |
END |