dbo.tbl_bom

Description

Properties

Name	Value
Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	20411
Created	1/9/2013 11:11:43
Last Modified	8/12/2017 22:12:09

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_bom_hdr	bigint	8	19	0	True	1 - 1	False	False
ASSY_CODE	varchar	50	0	0	True		False	False
ASSY_NO	varchar	50	0	0	False		False	False
filename	varchar	500	0	0	False		False	False
itemcount	int	4	10	0	False		False	False
dateexec	datetime	8	23	3	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_bom_hdr	id_bom_hdr, ASSY_CODE	True

SQL Script

CREATE TABLE dbo.tbl_bom_hdr (
  id_bom_hdr bigint IDENTITY,
  ASSY_CODE varchar(50) NOT NULL,
  ASSY_NO varchar(50) NULL,
  filename varchar(500) NULL,
  itemcount int NULL,
  dateexec datetime NULL,
  CONSTRAINT PK_tbl_bom_hdr PRIMARY KEY CLUSTERED (id_bom_hdr, ASSY_CODE) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_bom_hdr