[regex][mssql] CREATE INDEX

expression

/(CREATE)\s(INDEX)\s(#|@)+(.*?)\s(ON)\s(#|@)+(.*?)\((.*)\)+(;|)/g

matches

X - CREATE TABLE #TPE_04C (C_COA CHAR(3))
X - CREATE TABLE #TFP_14D (C_UNT CHAR(3), C_COA CHAR(3), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY)
X - CREATE TABLE #TFP_14D1 (S_SORT INT, CN_COA VARCHAR(50), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY)
O - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC)
O - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC);
O - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC, C_INDEX, USE_YN)
O - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC, C_INDEX, USE_YN, CREATE_DATE);

demo link

https://regexr.com/44pcq