Project
>
DEVSQL2016EA172
>
User databases
>
CoSample_17_2
>
Tables
> dbo.rptRPReportLeases_EX
[dbo].[rptRPReportLeases_EX]
Properties
Property
Value
Row Count (~)
0
Created
12:58:50 AM Thursday, March 21, 2019
Last Modified
1:14:04 AM Thursday, March 21, 2019
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
ReportLeaseID
int
4
False
LeaseID
int
4
False
Indexes
Key
Name
Key Columns
Unique
Fill Factor
PK_rptRPReportLeases_EX
ReportLeaseID
True
80
SQL Script
CREATE
TABLE
[dbo]
.
[rptRPReportLeases_EX]
(
[ReportLeaseID]
[int]
NOT
NULL
,
[LeaseID]
[int]
NOT
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[rptRPReportLeases_EX]
ADD
CONSTRAINT
[PK_rptRPReportLeases_EX]
PRIMARY
KEY
CLUSTERED
(
[ReportLeaseID]
)
ON
[PRIMARY]
GO
Used By
[dbo].[rptGLPresTransDetails_EX]