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 (~) | 299759 |
| Created | 8/23/2013 1:18:31 PM |
| Last Modified | 7/22/2017 11:00:14 PM |
Columns
11| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| informe | int | 4 | 10 | 0 | True |
False |
False |
|||||
| cuadro | tinyint | 1 | 3 | 0 | True |
False |
False |
|||||
| linea | tinyint | 1 | 3 | 0 | True |
False |
False |
|||||
| col1 | text | 0 | 0 | False |
False |
False |
||||||
| col2 | text | 0 | 0 | False |
False |
False |
||||||
| col3 | text | 0 | 0 | False |
False |
False |
||||||
| col4 | text | 0 | 0 | False |
False |
False |
||||||
| col5 | text | 0 | 0 | False |
False |
False |
||||||
| col6 | text | 0 | 0 | False |
False |
False |
||||||
| col7 | text | 0 | 0 | False |
False |
False |
||||||
| col8 | text | 0 | 0 | False |
False |
False |
Indexes
1SQL Script
Copy
CREATE TABLE dbo.cc_datos (
informe int NOT NULL,
cuadro tinyint NOT NULL,
linea tinyint NOT NULL,
col1 text NULL,
col2 text NULL,
col3 text NULL,
col4 text NULL,
col5 text NULL,
col6 text NULL,
col7 text NULL,
col8 text NULL,
PRIMARY KEY NONCLUSTERED (informe, cuadro, linea) WITH (FILLFACTOR = 20)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
informe int NOT NULL,
cuadro tinyint NOT NULL,
linea tinyint NOT NULL,
col1 text NULL,
col2 text NULL,
col3 text NULL,
col4 text NULL,
col5 text NULL,
col6 text NULL,
col7 text NULL,
col8 text NULL,
PRIMARY KEY NONCLUSTERED (informe, cuadro, linea) WITH (FILLFACTOR = 20)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
Depends On
1- Fidelitas