dbo.AGB_LN_campos

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 (~)	705
Created	5/2/2023 9:29:01 AM
Last Modified	5/2/2023 9:29:01 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
campo	int	4	10	0	True	False	False
nombre_campo	varchar	100	0	0	False	False	False
etiqueta	varchar	500	0	0	False	False	False
tipo_campo	varchar	1	0	0	False	False	False
longitud	smallint	2	5	0	False	False	False
decimales	tinyint	1	3	0	False	False	False
opciones	text		0	0	False	False	False
validacion	varchar	1	0	0	False	False	False
created	datetime	8	23	3	True	False	False
created_by	int	4	10	0	False	False	False
modified	datetime	8	23	3	False	False	False
modified_by	int	4	10	0	False	False	False
filas	tinyint	1	3	0	False	False	False
columnas	tinyint	1	3	0	False	False	False
anual_vencida	tinyint	1	3	0	False	False	False
aplica_formula_dep_econ	tinyint	1	3	0	False	False	False
tipo_attach	varchar	1	0	0	False	False	False

SQL Script

Copy

CREATE TABLE dbo.AGB_LN_campos (
  campo int NOT NULL,
  nombre_campo varchar(100) NULL,
  etiqueta varchar(500) NULL,
  tipo_campo varchar(1) NULL,
  longitud smallint NULL,
  decimales tinyint NULL,
  opciones text NULL,
  validacion varchar(1) NULL,
  created datetime NOT NULL,
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  filas tinyint NULL,
  columnas tinyint NULL,
  anual_vencida tinyint NULL,
  aplica_formula_dep_econ tinyint NULL,
  tipo_attach varchar(1) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found