CREATE INDEX (2) 썸네일형 리스트형 [regex][mssql] CRATE TABLE expression /CREATE\s(TABLE)\s(#|@)+(.*?)\s\((.*)\)+(;|)/g matches O - CREATE TABLE #TPE_04C (C_COA CHAR(3)); O - CREATE TABLE #TFP_14D (C_UNT CHAR(3), C_COA CHAR(3), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) O - CREATE TABLE #TFP_14D1 (S_SORT INT, CN_COA VARCHAR(50), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) X - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC) demo link https://regexr.com/44.. [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 IN.. 이전 1 다음