Skip to content

Support SQL Server #5

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]

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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