dbo.tbl_incoming

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 (~)	3965
Created	1/16/2013 02:12:05
Last Modified	11/18/2016 23:31:46

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_incoming_fg_hdr	bigint	8	19	0	True	1 - 1	False	False
from_file_name	varchar	500	0	0	False		False	False
exec_date	datetime	8	23	3	False		False	False
status	varchar	50	0	0	False		False	False
itemcount	int	4	10	0	False		False	False
countrow	int	4	10	0	False		False	False
incoming_date	date	3	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	ix_auto_tbl_incoming_fg_20161019_0001	status	False
	PK_tbl_incoming_fg_dtl	id_incoming_fg_hdr	True

SQL Script

CREATE TABLE dbo.tbl_incoming_fg (
  id_incoming_fg_hdr bigint IDENTITY,
  from_file_name varchar(500) NULL,
  exec_date datetime NULL,
  status varchar(50) NULL,
  itemcount int NULL,
  countrow int NULL,
  incoming_date date NULL,
  CONSTRAINT PK_tbl_incoming_fg_dtl PRIMARY KEY CLUSTERED (id_incoming_fg_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_incoming_fg_20161019_0001
  ON dbo.tbl_incoming_fg (status)
  INCLUDE (id_incoming_fg_hdr, from_file_name, exec_date, itemcount, countrow, incoming_date)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_incoming_fg