dbo.tbl_inv

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 (~)	41205
Created	12/7/2016 17:32:54
Last Modified	12/7/2016 17:33:01

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	inv_hdr_id	bigint	8	19	0	True	1 - 1	False	False
	r1	varchar	10	0	0	False		False	False
5	r2	varchar	51	0	0	False		False	False
2	r3	varchar	30	0	0	False		False	False
	r4	varchar	30	0	0	False		False	False
	r5	varchar	30	0	0	False		False	False
	r6	varchar	10	0	0	False		False	False
	r7	varchar	13	0	0	False		False	False
	r8	varchar	15	0	0	False		False	False
	r9	varchar	14	0	0	False		False	False
	r10	varchar	8	0	0	False		False	False
	r11	varchar	8	0	0	False		False	False
	r12	varchar	10	0	0	False		False	False
	r13	varchar	10	0	0	False		False	False
	r14	varchar	10	0	0	False		False	False
	r15	varchar	8	0	0	False		False	False
	r16	varchar	10	0	0	False		False	False
	r17	varchar	7	0	0	False		False	False
	r18	varchar	14	0	0	False		False	False
	r19	varchar	25	0	0	False		False	False
	r20	varchar	10	0	0	False		False	False
	date_create	datetime	8	23	3	False		False	False
5	status_inv	int	4	10	0	False		False	False
	car	varchar	30	0	0	False		False	False
	nobc	varchar	10	0	0	False		False	False
	tglbc	datetime	8	23	3	False		False	False
	nobl	varchar	50	0	0	False		False	False
	tgbl	date	3	10	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_inv_hdr_20161008_0001	r1, r2, r3, r5	False
ix_auto_tbl_inv_hdr_20161008_0002	r2, status_inv	False
ix_auto_tbl_inv_hdr_20161008_0003	status_inv	False
ix_auto_tbl_inv_hdr_20161008_0004	status_inv	False
ix_auto_tbl_inv_hdr_20161008_0005	status_inv	False
ix_auto_tbl_inv_hdr_20161008_0006	r2, status_inv	False
ix_auto_tbl_inv_hdr_20161008_0007	r2	False
ix_auto_tbl_inv_hdr_20161008_0008	r2	False
ix_auto_tbl_inv_hdr_20161008_0009	nobl, tgbl	False
ix_auto_tbl_inv_hdr_20161008_0010	r3	False
PK_tbl_inv_hdr	inv_hdr_id	True

SQL Script

CREATE TABLE dbo.tbl_inv_hdr (
  inv_hdr_id bigint IDENTITY,
  r1 varchar(10) NULL,
  r2 varchar(51) NULL,
  r3 varchar(30) NULL,
  r4 varchar(30) NULL,
  r5 varchar(30) NULL,
  r6 varchar(10) NULL,
  r7 varchar(13) NULL,
  r8 varchar(15) NULL,
  r9 varchar(14) NULL,
  r10 varchar(8) NULL,
  r11 varchar(8) NULL,
  r12 varchar(10) NULL,
  r13 varchar(10) NULL,
  r14 varchar(10) NULL,
  r15 varchar(8) NULL,
  r16 varchar(10) NULL,
  r17 varchar(7) NULL,
  r18 varchar(14) NULL,
  r19 varchar(25) NULL,
  r20 varchar(10) NULL,
  date_create datetime NULL,
  status_inv int NULL,
  car varchar(30) NULL,
  nobc varchar(10) NULL,
  tglbc datetime NULL,
  nobl varchar(50) NULL,
  tgbl date NULL,
  CONSTRAINT PK_tbl_inv_hdr PRIMARY KEY CLUSTERED (inv_hdr_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0001
  ON dbo.tbl_inv_hdr (r1, r2, r3, r5)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0002
  ON dbo.tbl_inv_hdr (r2, status_inv)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0003
  ON dbo.tbl_inv_hdr (status_inv)
  INCLUDE (r2)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0004
  ON dbo.tbl_inv_hdr (status_inv)
  INCLUDE (r2, r3)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0005
  ON dbo.tbl_inv_hdr (status_inv)
  INCLUDE (inv_hdr_id, r1, r2, r3, r4, tgbl, r17, r18, r19, r20, date_create, nobl, r11, r12, r13, r14, r15, r16, r5, r6, r7, r8, r9, r10)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0006
  ON dbo.tbl_inv_hdr (r2, status_inv)
  INCLUDE (r3)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0007
  ON dbo.tbl_inv_hdr (r2)
  INCLUDE (r3)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0008
  ON dbo.tbl_inv_hdr (r2)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0009
  ON dbo.tbl_inv_hdr (nobl, tgbl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_hdr_20161008_0010
  ON dbo.tbl_inv_hdr (r3)
  INCLUDE (inv_hdr_id)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_inv_hdr