NJC__Documentation::DB

dbo.tbl_data_part_hs_article

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 (~) 3504
Created 5/31/2017 13:39:10
Last Modified 5/31/2017 13:39:10

Columns

Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
id_konv_part bigint 8 19 0

True

1 - 1

False

False

part_no varchar 50 0 0

False

False

False

part_no2 varchar 50 0 0

False

False

False

article_code varchar 50 0 0

False

False

False

Indexes

Key Name Columns Unique Type Description
PK_tbl_data_part_hs_article id_konv_part

True

SQL Script

CREATE TABLE dbo.tbl_data_part_hs_article (
  id_konv_part bigint IDENTITY,
  part_no varchar(50) NULL,
  part_no2 varchar(50) NULL,
  article_code varchar(50) NULL,
  CONSTRAINT PK_tbl_data_part_hs_article PRIMARY KEY CLUSTERED (id_konv_part)
)
ON [PRIMARY]
GO

Depends On

No items found