C# RegEx get attributes from CREATE TABLE

Question

I need a RegEx to get name of table, keys and every attribute from CREATE TABLE statement... for example: Here I create this table, and i need to get all attributes

CREATE
  TABLE KATEGORIE
  (
    id INTEGER NOT NULL ,
    nazev NVARCHAR (20) NOT NULL ,
    cena INTEGER NOT NULL ,
    CONSTRAINT KATEGORIE_PK PRIMARY KEY CLUSTERED (id)
WITH
  (
    ALLOW_PAGE_LOCKS = ON ,
    ALLOW_ROW_LOCKS  = ON
  )
  ON "default"
  )
  ON "default"
GO

So far I have this: \s*CREATE\s*TABLE\s*(.*)\s*\(\s*(.*\s*) ; but this wont work, because there is always different number of attributes, I need to get all of them and end when word "WITH" or ')' shows up. Thanks for any help.

I'd suggest finding a SQL parser instead. Check out msdn.microsoft.com/en-us/library/… — juharr
– juharr, Commented Oct 5, 2015 at 15:45

6972Honza · Accepted Answer · 2015-10-06 16:05:35Z

1

I figured it out, thanks for help. I edited regex, for taking anything before ',' and i iterate through it, then i get last line.

answered Oct 6, 2015 at 16:05

6972Honza

335 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# RegEx get attributes from CREATE TABLE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related