Project
>
DEVSQL2016EA172
>
User databases
>
CoSystem
>
Tables
> dbo.Tally
[dbo].[Tally]
Properties
Property
Value
Row Count (~)
3000000
Created
11:24:31 AM Wednesday, May 9, 2018
Last Modified
11:24:48 AM Wednesday, May 9, 2018
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
Identity
N
int
4
False
1 - 1
Indexes
Key
Name
Key Columns
Unique
Fill Factor
PK_Tally
N
True
100
SQL Script
CREATE
TABLE
[dbo]
.
[Tally]
(
[N]
[int]
NOT
NULL
IDENTITY
(
1
,
1
)
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[Tally]
ADD
CONSTRAINT
[PK_Tally]
PRIMARY
KEY
CLUSTERED
(
[N]
)
ON
[PRIMARY]
GO