dbo.clie_prod

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 (~)	425
Created	9/8/2023 12:29:27 PM
Last Modified	9/8/2023 12:32:59 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
cli_codigo	varchar	50	0	False	False	False
prod_codigo_viejo	varchar	50	0	False	False	False
prod_codigo_nuevo	varchar	50	0	False	False	False
lista	varchar	50	0	False	False	False
prod_bonif	varchar	50	0	False	False	False
prod_periodo_desde	varchar	50	0	False	False	False
prod_periodo_hasta	varchar	50	0	False	False	False
prod_car_min	varchar	50	0	False	False	False
cli_fecha_act	varchar	50	0	False	False	False
cli_usuario	varchar	50	0	False	False	False
producto	int	4	10	False	False	False

SQL Script

Copy

CREATE TABLE dbo.clie_prod_2015 (
  cli_codigo varchar(50) NULL,
  prod_codigo_viejo varchar(50) NULL,
  prod_codigo_nuevo varchar(50) NULL,
  lista varchar(50) NULL,
  prod_bonif varchar(50) NULL,
  prod_periodo_desde varchar(50) NULL,
  prod_periodo_hasta varchar(50) NULL,
  prod_car_min varchar(50) NULL,
  cli_fecha_act varchar(50) NULL,
  cli_usuario varchar(50) NULL,
  producto int NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found