dbo.tbl_bc_out

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 (~)	146425
Created	2/23/2013 07:54:24
Last Modified	11/18/2016 22:54:45

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_bc_out_dok	bigint	8	19	True	1 - 1	False	False
id_bc_out_hdr	bigint	8	19	True		False	False
CAR	varchar	26	0	False		False	False
KdDok	varchar	3	0	False		False	False
NoDok	varchar	30	0	False		False	False
TgDok	date	3	10	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_bc_out_dok_20161008_0001	id_bc_out_hdr	False
ix_auto_tbl_bc_out_dok_20161019_0001	NoDok	False
PK_tbl_bc_out_dok	id_bc_out_dok	True

SQL Script

CREATE TABLE dbo.tbl_bc_out_dok (
  id_bc_out_dok bigint IDENTITY,
  id_bc_out_hdr bigint NOT NULL,
  CAR varchar(26) NULL,
  KdDok varchar(3) NULL,
  NoDok varchar(30) NULL,
  TgDok date NULL,
  CONSTRAINT PK_tbl_bc_out_dok PRIMARY KEY CLUSTERED (id_bc_out_dok) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_out_dok_20161008_0001
  ON dbo.tbl_bc_out_dok (id_bc_out_hdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_out_dok_20161019_0001
  ON dbo.tbl_bc_out_dok (NoDok)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_bc_out_dok