dbo.LN_MOCK_CLIENTES

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 (~)	31
Created	11/19/2020 4:26:28 PM
Last Modified	11/19/2020 5:34:47 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_mock	int	4	10	True	1 - 1	False	False
cliente	int	4	10	False		False	False
nombre_cliente	varchar	150	0	False		False	False
cli_codigo	int	4	10	False		False	False
familia	int	4	10	False		False	False
nombre_familia	varchar	150	0	False		False	False
set_doc	int	4	10	False		False	False
nombre_set_doc	varchar	150	0	False		False	False
2023	char	1	0	False		False	False
2033	char	1	0	False		False	False
2052	char	1	0	False		False	False
2048	char	1	0	False		False	False
2005	char	1	0	False		False	False
2024	char	1	0	False		False	False
2013	char	1	0	False		False	False
2036	char	1	0	False		False	False
2022	char	1	0	False		False	False
2047	char	1	0	False		False	False
4	char	1	0	False		False	False
2003	char	1	0	False		False	False
2016	char	1	0	False		False	False
2045	char	1	0	False		False	False
2004	char	1	0	False		False	False
2020	char	1	0	False		False	False
2030	char	1	0	False		False	False
2035	char	1	0	False		False	False
2021	char	1	0	False		False	False
2029	char	1	0	False		False	False
2032	char	1	0	False		False	False
2025	char	1	0	False		False	False
2031	char	1	0	False		False	False
2002	char	1	0	False		False	False
2044	char	1	0	False		False	False

SQL Script

Copy

CREATE TABLE dbo.LN_MOCK_CLIENTES_PRODUCTOS (
  id_mock int IDENTITY,
  cliente int NULL,
  nombre_cliente varchar(150) NULL,
  cli_codigo int NULL,
  familia int NULL,
  nombre_familia varchar(150) NULL,
  set_doc int NULL,
  nombre_set_doc varchar(150) NULL,
  [2023] char(1) NULL,
  [2033] char(1) NULL,
  [2052] char(1) NULL,
  [2048] char(1) NULL,
  [2005] char(1) NULL,
  [2024] char(1) NULL,
  [2013] char(1) NULL,
  [2036] char(1) NULL,
  [2022] char(1) NULL,
  [2047] char(1) NULL,
  [4] char(1) NULL,
  [2003] char(1) NULL,
  [2016] char(1) NULL,
  [2045] char(1) NULL,
  [2004] char(1) NULL,
  [2020] char(1) NULL,
  [2030] char(1) NULL,
  [2035] char(1) NULL,
  [2021] char(1) NULL,
  [2029] char(1) NULL,
  [2032] char(1) NULL,
  [2025] char(1) NULL,
  [2031] char(1) NULL,
  [2002] char(1) NULL,
  [2044] char(1) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found