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 (~) | 994 |
| Created | 12/5/2023 9:39:16 AM |
| Last Modified | 12/5/2023 9:39:16 AM |
Columns
10| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| anio | numeric | 9 | 18 | 0 | False |
False |
False |
|||||
| mes | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| periodo | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| country_code | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| country_name | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| umbral_limite | decimal | 13 | 28 | 0 | False |
False |
False |
|||||
| umbral_alerta | decimal | 13 | 28 | 0 | False |
False |
False |
|||||
| facturacion_12_meses | decimal | 13 | 28 | 0 | False |
False |
False |
|||||
| desde | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| hasta | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.limites (
anio numeric NULL,
mes varchar(50) NULL,
periodo varchar(50) NULL,
country_code varchar(50) NULL,
country_name varchar(50) NULL,
umbral_limite decimal(28) NULL,
umbral_alerta decimal(28) NULL,
facturacion_12_meses decimal(28) NULL,
desde varchar(50) NULL,
hasta varchar(50) NULL
)
ON [PRIMARY]
GO
anio numeric NULL,
mes varchar(50) NULL,
periodo varchar(50) NULL,
country_code varchar(50) NULL,
country_name varchar(50) NULL,
umbral_limite decimal(28) NULL,
umbral_alerta decimal(28) NULL,
facturacion_12_meses decimal(28) NULL,
desde varchar(50) NULL,
hasta varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found