Skip to content

Support SQL Server #5

@Jerome2606

Description

@Jerome2606

Hello,

Your project seems very nice for me.
Would be nice if the grammar would support SQL Server syntax as well.

Here's an example:

CREATE TABLE [DEBUG](
[row] [int] IDENTITY(1,1) NOT NULL,
[text] nvarchar NULL,
CONSTRAINT [PK_debug] PRIMARY KEY CLUSTERED
(
[row] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [T_CLIENT_CLI](
[CLI_ID] [bigint] IDENTITY(1,1) NOT NULL,
[CLI_NAME] nvarchar NOT NULL,
[CLI_PARENT_ID] [bigint] NULL,
CONSTRAINT [PK_T_CLIENT_CLI] PRIMARY KEY CLUSTERED
(
[CLI_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [T_DASHBOARD_DAB](
[DAB_ID] [bigint] IDENTITY(1,1) NOT NULL,
[DAB_CLI_ID] [bigint] NULL,
[DAB_USR_ID] [bigint] NULL,
[DAB_DAS_ID] [bigint] NULL,
[DAB_REFERENCE] nvarchar NOT NULL,
[DAB_REFRESH] [int] NOT NULL,
[DAB_TRANSITION] [int] NOT NULL,
[DAB_DISPLAY_TYPE] [tinyint] NOT NULL,
[DAB_CONFIG] nvarchar NOT NULL,
CONSTRAINT [PK_T_DASHBOARD_DAC] PRIMARY KEY CLUSTERED
(
[DAB_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [T_DASHBOARD_DAB] ADD CONSTRAINT [DF_T_DASHBOARD_DAB_DAB_REFRESH] DEFAULT ((1)) FOR [DAB_REFRESH]

ALTER TABLE [T_CLIENT_CLI] WITH CHECK ADD CONSTRAINT [FK_CLI_PARENT] FOREIGN KEY([CLI_PARENT_ID])
REFERENCES [T_CLIENT_CLI] ([CLI_ID])

ALTER TABLE [T_CLIENT_CLI] CHECK CONSTRAINT [FK_CLI_PARENT]

ALTER TABLE [T_DASHBOARD_DAB] WITH CHECK ADD CONSTRAINT [FK_DAB_CLI_ID] FOREIGN KEY([DAB_CLI_ID])
REFERENCES [T_CLIENT_CLI] ([CLI_ID])
ON DELETE CASCADE

ALTER TABLE [T_DASHBOARD_DAB] CHECK CONSTRAINT [FK_DAB_CLI_ID]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions