Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE [dbo].[Titles](
[Titlecode] [decimal](13, 0) NOT NULL,
[ListCode] [char](3) NULL,
[ZLineNumber] [int] NOT NULL,
[ZLineRateCode] [char](3) NULL,
[ZLineComment] [varchar](30) NULL,
CONSTRAINT [pk_Titles] PRIMARY KEY CLUSTERED
(
[Titlecode] ASC,
[ZLineNumber] ASC
))
CREATE NONCLUSTERED INDEX [nc_ListCode] ON [dbo].[Titles]
(
[ListCode] ASC
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.