dbo.users

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:55 PM
Last Modified	3/6/2025 6:55:55 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
user_id	int	4	10	0	True	False	False
cli_codigo	int	4	10	0	False	False	False
username	varchar	60	0	0	False	False	False
password	varchar	20	0	0	False	False	False
first_name	varchar	30	0	0	False	False	False
last_name	varchar	30	0	0	False	False	False
gender	varchar	1	0	0	False	False	False
birthday	datetime	8	23	3	False	False	False
email	varchar	500	0	0	False	False	False
home_email	varchar	100	0	0	False	False	False
beeper_mail	varchar	100	0	0	False	False	False
icq_number	varchar	20	0	0	False	False	False
cookie_id	varchar	120	0	0	False	False	False
work_phone	varchar	20	0	0	False	False	False
home_phone	varchar	20	0	0	False	False	False
cell_phone	varchar	20	0	0	False	False	False
work_fax	varchar	20	0	0	False	False	False
home_fax	varchar	20	0	0	False	False	False
pager	varchar	25	0	0	False	False	False
address	varchar	120	0	0	False	False	False
zip	varchar	12	0	0	False	False	False
city	varchar	30	0	0	False	False	False
state	varchar	20	0	0	False	False	False
country_code	varchar	2	0	0	False	False	False
organization	varchar	80	0	0	False	False	False
position	varchar	80	0	0	False	False	False
last_login	datetime	8	23	3	False	False	False
login_state	varchar	1	0	0	False	False	False
rows_per_page	int	4	10	0	False	False	False
user_created	datetime	8	23	3	False	False	False
preferences_modified	datetime	8	23	3	False	False	False
preferences	text		0	0	False	False	False
active_user	varchar	1	0	0	False	False	False
last_access	datetime	8	23	3	False	False	False
idioma	smallint	2	5	0	False	False	False
login_expiration	datetime	8	23	3	False	False	False

SQL Script

Copy

CREATE TABLE dbo.users_new (
  user_id int NOT NULL,
  cli_codigo int NULL,
  username varchar(60) NULL,
  password varchar(20) NULL,
  first_name varchar(30) NULL,
  last_name varchar(30) NULL,
  gender varchar(1) NULL,
  birthday datetime NULL,
  email varchar(500) NULL,
  home_email varchar(100) NULL,
  beeper_mail varchar(100) NULL,
  icq_number varchar(20) NULL,
  cookie_id varchar(120) NULL,
  work_phone varchar(20) NULL,
  home_phone varchar(20) NULL,
  cell_phone varchar(20) NULL,
  work_fax varchar(20) NULL,
  home_fax varchar(20) NULL,
  pager varchar(25) NULL,
  address varchar(120) NULL,
  zip varchar(12) NULL,
  city varchar(30) NULL,
  state varchar(20) NULL,
  country_code varchar(2) NULL,
  organization varchar(80) NULL,
  position varchar(80) NULL,
  last_login datetime NULL,
  login_state varchar(1) NULL,
  rows_per_page int NULL,
  user_created datetime NULL,
  preferences_modified datetime NULL,
  preferences text NULL,
  active_user varchar(1) NULL,
  last_access datetime NULL,
  idioma smallint NULL,
  login_expiration datetime NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found