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# [url removed, login to view] method._