Project
>
DEVSQL2016EA172
>
User databases
>
CoSystem
>
Tables
> dbo.CoDBTypes
[dbo].[CoDBTypes]
Properties
Property
Value
Collation
SQL_Latin1_General_CP1_CI_AS
Row Count (~)
3
Created
11:24:18 AM Wednesday, May 9, 2018
Last Modified
11:24:47 AM Wednesday, May 9, 2018
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
Identity
DBTypeID
int
4
False
1 - 1
DBType
varchar(30)
30
False
Indexes
Key
Name
Key Columns
Unique
PK_CoDBTypes
DBTypeID
True
SQL Script
CREATE
TABLE
[dbo]
.
[CoDBTypes]
(
[DBTypeID]
[int]
NOT
NULL
IDENTITY
(
1
,
1
),
[DBType]
[varchar]
(
30
)
COLLATE
SQL_Latin1_General_CP1_CI_AS
NOT
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[CoDBTypes]
ADD
CONSTRAINT
[PK_CoDBTypes]
PRIMARY
KEY
CLUSTERED
(
[DBTypeID]
)
ON
[PRIMARY]
GO
Used By
[dbo].[CoCompanies]