Project
>
DEVSQL2016EA172
>
User databases
>
CoSample_17_2
>
Tables
> dbo.ICItems1
[dbo].[ICItems1]
Properties
Property
Value
Row Count (~)
0
Created
12:57:31 AM Thursday, March 21, 2019
Last Modified
1:16:13 AM Thursday, March 21, 2019
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
ItemID
int
4
False
timestamp
timestamp
8
False
Indexes
Key
Name
Key Columns
Unique
Fill Factor
PK_ICItems1
ItemID
True
80
SQL Script
CREATE
TABLE
[dbo]
.
[ICItems1]
(
[ItemID]
[int]
NOT
NULL
,
[timestamp]
[timestamp]
NOT
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[ICItems1]
ADD
CONSTRAINT
[PK_ICItems1]
PRIMARY
KEY
CLUSTERED
(
[ItemID]
)
ON
[PRIMARY]
GO
Used By
[dbo].[ICItemRelatedItems]
[dbo].[ICItemUnits]
[dbo].[POOrderDetails]
[dbo].[POQOrderDetails]
[dbo].[POQuoteDetails]
[dbo].[POReceiptDetails]
[dbo].[POVoucherDetails]
[dbo].[SCBillCodeExcludes]
[dbo].[SCEquipmentProfileHistory]
[dbo].[SCEquipments]
[dbo].[SCQReportMaterials]
[dbo].[SCReportMaterials]
[dbo].[SCReturnedItems]
[dbo].[SOInvoiceDetails]
[dbo].[SOOrderDetails]
[dbo].[SOPicketDetails]
[dbo].[SOQuoteDetails]