dbo.temp_cendeu_para_score

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 (~) 938534
Created 7/5/2019 11:56:53 AM
Last Modified 7/5/2019 12:08:57 PM

Columns

15
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
id_tabla int 4 10 0

True

1 - 1

False

False

iden varchar 20 0 0

False

False

False

situacion varchar 2 0 0

False

False

False

codigo_ent varchar 5 0 0

False

False

False

prestamos numeric 9 12 1

False

False

False

particip numeric 9 12 1

False

False

False

garotor numeric 9 12 1

False

False

False

o_cptos numeric 9 12 1

False

False

False

garprefb numeric 9 12 1

False

False

False

singarpref numeric 9 12 1

False

False

False

cgarprefa numeric 9 12 1

False

False

False

cgarprefb numeric 9 12 1

False

False

False

sincgarpre numeric 9 12 1

False

False

False

fec_inf varchar 6 0 0

False

False

False

garprefa numeric 9 12 1

False

False

False

SQL Script

Copy
CREATE TABLE dbo.temp_cendeu_para_score (
  id_tabla int IDENTITY,
  iden varchar(20) NULL,
  situacion varchar(2) NULL,
  codigo_ent varchar(5) NULL,
  prestamos numeric(12, 1) NULL,
  particip numeric(12, 1) NULL,
  garotor numeric(12, 1) NULL,
  o_cptos numeric(12, 1) NULL,
  garprefb numeric(12, 1) NULL,
  singarpref numeric(12, 1) NULL,
  cgarprefa numeric(12, 1) NULL,
  cgarprefb numeric(12, 1) NULL,
  sincgarpre numeric(12, 1) NULL,
  fec_inf varchar(6) NULL,
  garprefa numeric(12, 1) NULL
)
ON [PRIMARY]
GO

Depends On

1
  • Fidelitas

Used By

No items found