Skip to content

Instantly share code, notes, and snippets.

@ssukhpinder

ssukhpinder/create-table-profiling.sql

Created July 30, 2020 18:50
Show Gist options
  • Save ssukhpinder/6cfeed66bd06370cfd73eed1701f946d to your computer and use it in GitHub Desktop.
Save ssukhpinder/6cfeed66bd06370cfd73eed1701f946d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-table-profiling.sql
CREATE TABLE [dbo].[test_table](
[testid] [int] identity(1,1) NOT NULL,
[testname] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_test_table] PRIMARY KEY CLUSTERED
(
[testid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment