[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/44pck