dbo.tblImportir

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 (~)	1
Created	1/9/2013 13:58:44
Last Modified	11/18/2016 22:54:33

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
IMPID	varchar	1	0	0	True	False	False
IMPNPWP	varchar	15	0	0	True	False	False
KdTPB	varchar	1	0	0	True	False	False
Registrasi	varchar	20	0	0	True	False	False
IMPNAMA	varchar	50	0	0	False	False	False
IMPALMT	varchar	70	0	0	False	False	False
APIKD	varchar	1	0	0	False	False	False
APINO	varchar	15	0	0	False	False	False
UsahaStatus	varchar	2	0	0	False	False	False
KotaTtd	varchar	30	0	0	False	False	False
Namattd	varchar	30	0	0	False	False	False
ContakPerson	varchar	30	0	0	False	False	False
NoPhone	varchar	25	0	0	False	False	False
NoFax	varchar	25	0	0	False	False	False
Email	varchar	50	0	0	False	False	False
NoSkep	varchar	20	0	0	False	False	False
TgSkep	datetime	8	23	3	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__tblImpor__CBEADAE03592E0D8	IMPID, IMPNPWP, KdTPB, Registrasi	True

SQL Script

CREATE TABLE dbo.tblImportir (
  IMPID varchar(1) NOT NULL,
  IMPNPWP varchar(15) NOT NULL,
  KdTPB varchar(1) NOT NULL,
  Registrasi varchar(20) NOT NULL,
  IMPNAMA varchar(50) NULL,
  IMPALMT varchar(70) NULL,
  APIKD varchar(1) NULL,
  APINO varchar(15) NULL,
  UsahaStatus varchar(2) NULL,
  KotaTtd varchar(30) NULL,
  Namattd varchar(30) NULL,
  ContakPerson varchar(30) NULL,
  NoPhone varchar(25) NULL,
  NoFax varchar(25) NULL,
  Email varchar(50) NULL,
  NoSkep varchar(20) NULL,
  TgSkep datetime NULL,
  PRIMARY KEY CLUSTERED (IMPID, IMPNPWP, KdTPB, Registrasi) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found