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 (~) | 0 |
| Created | 3/6/2025 6:55:54 PM |
| Last Modified | 3/6/2025 6:55:54 PM |
Columns
35| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTA | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| MARCA | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| TMARCA | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TIPO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| CLASE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| NBOL | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TEXP | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PALABUS | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FPRE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FPUBLI | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TRESO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| NRESO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FRESO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| RENU_DE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| RENU_POR | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TITULAR | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| CODAGE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PAIS | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| COBERTURA | text | 0 | 0 | False |
False |
False |
||||||
| DISPCONCE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| DISPBOLE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| DISPFBOLE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PRIORIDAD | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FPRIORIDAD | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PPRIORIDAD | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FVTO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Column 26 | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| flag | char | 1 | 0 | 0 | False |
False |
False |
|||||
| modified | smalldatetime | 4 | 16 | 0 | False |
False |
False |
|||||
| cuit | varchar | 30 | 0 | 0 | False |
False |
False |
|||||
| directorio | bit | 1 | 1 | 0 | False |
False |
False |
|||||
| web | bit | 1 | 1 | 0 | False |
False |
False |
|||||
| web_fecha_modificacion | nchar | 30 | 0 | 0 | False |
False |
False |
|||||
| html | bit | 1 | 1 | 0 | False |
False |
False |
|||||
| idMarca | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
SQL Script
Copy
CREATE TABLE dbo.marcas (
ACTA varchar(150) NULL,
MARCA varchar(250) NULL,
TMARCA varchar(150) NULL,
TIPO varchar(150) NULL,
CLASE varchar(150) NULL,
NBOL varchar(150) NULL,
TEXP varchar(150) NULL,
PALABUS varchar(150) NULL,
FPRE varchar(150) NULL,
FPUBLI varchar(150) NULL,
TRESO varchar(150) NULL,
NRESO varchar(150) NULL,
FRESO varchar(150) NULL,
RENU_DE varchar(150) NULL,
RENU_POR varchar(150) NULL,
TITULAR varchar(250) NULL,
CODAGE varchar(150) NULL,
PAIS varchar(150) NULL,
COBERTURA text NULL,
DISPCONCE varchar(150) NULL,
DISPBOLE varchar(150) NULL,
DISPFBOLE varchar(150) NULL,
PRIORIDAD varchar(150) NULL,
FPRIORIDAD varchar(150) NULL,
PPRIORIDAD varchar(150) NULL,
FVTO varchar(150) NULL,
[Column 26] varchar(150) NULL,
flag char(1) NULL,
modified smalldatetime NULL,
cuit varchar(30) NULL,
directorio bit NULL,
web bit NULL,
web_fecha_modificacion nchar(30) NULL,
html bit NULL,
idMarca int IDENTITY
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ACTA varchar(150) NULL,
MARCA varchar(250) NULL,
TMARCA varchar(150) NULL,
TIPO varchar(150) NULL,
CLASE varchar(150) NULL,
NBOL varchar(150) NULL,
TEXP varchar(150) NULL,
PALABUS varchar(150) NULL,
FPRE varchar(150) NULL,
FPUBLI varchar(150) NULL,
TRESO varchar(150) NULL,
NRESO varchar(150) NULL,
FRESO varchar(150) NULL,
RENU_DE varchar(150) NULL,
RENU_POR varchar(150) NULL,
TITULAR varchar(250) NULL,
CODAGE varchar(150) NULL,
PAIS varchar(150) NULL,
COBERTURA text NULL,
DISPCONCE varchar(150) NULL,
DISPBOLE varchar(150) NULL,
DISPFBOLE varchar(150) NULL,
PRIORIDAD varchar(150) NULL,
FPRIORIDAD varchar(150) NULL,
PPRIORIDAD varchar(150) NULL,
FVTO varchar(150) NULL,
[Column 26] varchar(150) NULL,
flag char(1) NULL,
modified smalldatetime NULL,
cuit varchar(30) NULL,
directorio bit NULL,
web bit NULL,
web_fecha_modificacion nchar(30) NULL,
html bit NULL,
idMarca int IDENTITY
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found