SQL：表格创建学习笔记

CREATE TABLE

语法

CREATE TABLE "table_name"
("column 1" "data type for column 1" [column 1 constraint(s)],
"column 2" "data type for column 2" [column 2 constraint(s)],
...
[table constraint(s)] );

示例

CREATE TABLE Users
(
Id INT PRIMARY KEY,
UserType NVARCHAR(50) DEFAULT "管理员",
Username NVARCHAR(50) UNIQUE,
Password NVARCHAR(50) NOT NULL
)