Regular expression that parses an SQLLite create index statement

I need a regular expression that can parse an SQLLite create index statement. In the following SQLite create table & index statements: CREATE TABLE [Table 1] ([Column With Space] INT, ColumnWithoutSpace INT, Column3 INT); CREATE INDEX IndexOne on [Table 1] ([Column With Space] collate nocase DESC, ColumnWithoutSpace, Column3); CREATE INDEX IndexTwo on [Table 1] (Column3 ASC); CREATE INDEX IndexTree on [Table 1] ([Column With Space] ASC, Column3 collate NOCASE); Only the create index statements need to have a regular expression applied. The regular expression needs to find the following: 1. The table name that the index is being created on. 2. For EVERY column specified in the index: 2a. The column name 2b. The column collation (if specified) 2c. The column sort mode (if specified). The resulting regex must work with the C# [login to view URL] method._