Project
>
DEVSQL2016EA172
>
User databases
>
fmacentral_4_3_72
>
Tables
> dbo.BackupCO
[dbo].[BackupCO]
Properties
Property
Value
Row Count (~)
0
Created
1:20:01 AM Thursday, March 21, 2019
Last Modified
1:20:01 AM Thursday, March 21, 2019
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
ContactID
int
4
False
AccountID
int
4
False
UserType
int
4
False
Indexes
Key
Name
Key Columns
Unique
PK_BackupCO_ContactID
ContactID
True
SQL Script
CREATE
TABLE
[dbo]
.
[BackupCO]
(
[ContactID]
[int]
NOT
NULL
,
[AccountID]
[int]
NOT
NULL
,
[UserType]
[int]
NOT
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[BackupCO]
ADD
CONSTRAINT
[PK_BackupCO_ContactID]
PRIMARY
KEY
CLUSTERED
(
[ContactID]
)
ON
[PRIMARY]
GO