Write an SQL script to create a table called users in a database

Question

Write an SQL script to create a table called users in a database, with the following fields (assume the specific database has already been accessed) a.id, which is the primary key and value is provided by the database server b.username, which has an appropriate string format c.password, with a format specific for the SHA encryption algorithm d.reg_date, with an appropriate date format

Answer 1

Hi Muhammad,

CREATE TABLE Users (

Id INT IDENTITY(1,1),

Username VARCHAR(25) NOT NULL,

PasswordHash BINARY(64) NOT NULL,

reg_date DATETIME2 NOT NULL

CONSTRAINT PK_User PRIMARY KEY (Id)

);

Changed the column Password to PasswordHash since its bad practice to use reserved words. Could switch to use DateTime if you don't need the nano seconds, saves a bit on storage.

Regards.