// @nuget: TSQL.Parser

​

using System;

​

using TSQL;

using TSQL.Statements;

using TSQL.Tokens;

using System.Collections.Generic;

​

namespace TSQLParserExample

{

    public class Program

    {

        public static void Main(string[] args)

        {

            string script = @"          

                CREATE TABLE [dw-8023774-main].[StoreProductShrinkage]

                (

                    [StoreId] NVARCHAR(128) NOT NULL,

                    [ProductId] NVARCHAR(128) NOT NULL,

                    [UnitOfMeasureId] INT NOT NULL,

                    [ProductShrinkageTypeId] INT NOT NULL,

                    [StoreProductShrinkagePeriodStartDate] NVARCHAR(4000) NOT NULL,

                    [StoreProductShrinkagePeriodEndDate] NVARCHAR(4000) NULL,

                    [StoreProductEstimatedShrinkageValuePerUom] DECIMAL(18,4) NOT NULL,

                    [StoreProductActualShrinkageValuePerUom] DECIMAL(18,4) NOT NULL,

                    [StoreProductShrinkageNote] NVARCHAR(1024) NULL,

                    CONSTRAINT PK_StoreProductShrinkage PRIMARY KEY NONCLUSTERED (StoreId, ProductId, UnitOfMeasureId, ProductShrinkageTypeId, StoreProductShrinkagePeriodStartDate) NOT ENFORCED

                )

                WITH 

                (

                    CLUSTERED COLUMNSTORE INDEX,

                    DISTRIBUTION = ROUND_ROBIN

                )

            ";

​

            var statements = TSQL.TSQLStatementReader.ParseStatements(script, true, true);

            statements.ForEach(s => {

                s.Tokens.ForEach(t => {

                    Console.Write(t.Type.ToString()); Console.Write("\t"); Console.WriteLine(t.Text); Console.WriteLine();

                });         

            });

        }

    }

}