dbo.tbl_vgi

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 (~)	28837
Created	4/28/2013 10:38:22
Last Modified	11/18/2016 22:50:28

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_vgi_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
ISSUE_NO	varchar	50	0	0	False		False	False
REG_DATE	date	3	10	0	False		False	False
itemcount	int	4	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_vgi_hdr	id_vgi_hdr	True

SQL Script

CREATE TABLE dbo.tbl_vgi_hdr (
  id_vgi_hdr bigint IDENTITY,
  from_file_name varchar(500) NULL,
  exec_date datetime NULL,
  status varchar(50) NULL,
  ISSUE_NO varchar(50) NULL,
  REG_DATE date NULL,
  itemcount int NULL,
  CONSTRAINT PK_tbl_vgi_hdr PRIMARY KEY CLUSTERED (id_vgi_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_vgi_hdr