Project
>
DEVSQL2016EA172
>
User databases
>
CoSample_17_2
>
Tables
> dbo.WebFeatures
[dbo].[WebFeatures]
Properties
Property
Value
Collation
SQL_Latin1_General_CP1_CI_AS
Row Count (~)
0
Created
1:00:58 AM Thursday, March 21, 2019
Last Modified
1:00:58 AM Thursday, March 21, 2019
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
FeatureID
int
4
False
Description
varchar(50)
50
False
Indexes
Key
Name
Key Columns
Unique
Fill Factor
PK_WebFeatures
FeatureID
True
80
SQL Script
CREATE
TABLE
[dbo]
.
[WebFeatures]
(
[FeatureID]
[int]
NOT
NULL
,
[Description]
[varchar]
(
50
)
COLLATE
SQL_Latin1_General_CP1_CI_AS
NOT
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[WebFeatures]
ADD
CONSTRAINT
[PK_WebFeatures]
PRIMARY
KEY
CLUSTERED
(
[FeatureID]
)
ON
[PRIMARY]
GO