NJC__Documentation::DB

dbo.user_temp

Description

Properties

Name Value
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 11/19/2012 05:21:04
Last Modified 11/19/2012 05:21:04

Columns

Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
id int 4 10 0

True

False

False

username varchar 255 0 0

True

False

False

password varchar 34 0 0

True

False

False

email varchar 100 0 0

True

False

False

activation_key varchar 50 0 0

True

False

False

last_ip varchar 40 0 0

True

False

False

created datetime2 8 27 7

True

False

False

SQL Script

CREATE TABLE dbo.user_temp (
  id int NOT NULL,
  username varchar(255) NOT NULL,
  password varchar(34) NOT NULL,
  email varchar(100) NOT NULL,
  activation_key varchar(50) NOT NULL,
  last_ip varchar(40) NOT NULL,
  created datetime2 NOT NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found