dbo.ValidCSV

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	82
Created	12/19/2019 6:23:46 PM
Last Modified	12/19/2019 7:01:43 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
COMPANY	varchar	150	0	False			False	False
TAXID	varchar	150	0	False			False	False
COUNTRY	varchar	150	0	False			False	False
TYPE	varchar	150	0	False			False	False
TIER	varchar	150	0	False			False	False
CONTACTFIRSTNAME	varchar	150	0	False			False	False
CONTACTLASTNAME	varchar	150	0	False			False	False
CONTACTPOSITION	varchar	150	0	False			False	False
CONTACTMOBILE	varchar	150	0	False			False	False
PHONENUMBER	varchar	150	0	False			False	False
EMAIL	varchar	150	0	False			False	False
PROCESADO	bit	1	1	True		(0)	False	False
ID	int	4	10	True	1 - 1		False	False

SQL Script

Copy

CREATE TABLE dbo.ValidCSV (
  COMPANY varchar(150) NULL,
  TAXID varchar(150) NULL,
  COUNTRY varchar(150) NULL,
  TYPE varchar(150) NULL,
  TIER varchar(150) NULL,
  CONTACTFIRSTNAME varchar(150) NULL,
  CONTACTLASTNAME varchar(150) NULL,
  CONTACTPOSITION varchar(150) NULL,
  CONTACTMOBILE varchar(150) NULL,
  PHONENUMBER varchar(150) NULL,
  EMAIL varchar(150) NULL,
  PROCESADO bit NOT NULL DEFAULT (0),
  ID int IDENTITY
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found