dbo.AMX_Proveedores

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 (~) 314
Created 8/17/2016 3:51:29 PM
Last Modified 11/25/2016 4:25:41 PM

Columns

13
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
CUIT varchar 50 0 0

False

False

False

RazonSocial varchar 250 0 0

False

False

False

Nombre varchar 250 0 0

False

False

False

Email varchar 250 0 0

False

False

False

Emailalternativo varchar 250 0 0

False

False

False

Emailalternativo2 varchar 250 0 0

False

False

False

Inactivo varchar 50 0 0

False

False

False

Telefono varchar 150 0 0

False

False

False

Direccion varchar 250 0 0

False

False

False

CodigoAuxiliar varchar 50 0 0

False

False

False

FechaAlta varchar 50 0 0

False

False

False

FechaActivcacion varchar 50 0 0

False

False

False

last_modified datetime 8 23 3

False

(getdate())

False

False

SQL Script

Copy
CREATE TABLE dbo.AMX_Proveedores (
  CUIT varchar(50) NULL,
  RazonSocial varchar(250) NULL,
  Nombre varchar(250) NULL,
  Email varchar(250) NULL,
  Emailalternativo varchar(250) NULL,
  Emailalternativo2 varchar(250) NULL,
  Inactivo varchar(50) NULL,
  Telefono varchar(150) NULL,
  Direccion varchar(250) NULL,
  CodigoAuxiliar varchar(50) NULL,
  FechaAlta varchar(50) NULL,
  FechaActivcacion varchar(50) NULL,
  last_modified datetime NULL DEFAULT (getdate())
)
ON [PRIMARY]
GO

Depends On

1
  • Fidelitas

Used By

No items found