Question

sql 创建列表create table

Table name: Photo
Attribute name | Datatype | Modifiers

PhotoID integer primary key, values must be larger than zero ( > 0 )
Name varchar(30) all values must be unique; cannot be NULL.
Class varchar(30) gets by default 'Unclassified'; accepts only the following values: 'Unclassified', 'Nature', 'Family', 'Work', 'Travel', 'Misc'.

用CREATE TABLE创建以上这个数据库，新手求助，谢谢了

Answer 1

Create Table Photo(
PhotoId INT PRIMARY KEY CHECK(PhotoId>0),
Name NVARCHAR(30) NOT NULL UNIQUE (Name),
Class NVARCHAR(30) CHECK(Class IN ('Unclassified', 'Nature', 'Family', 'Work', 'Travel', 'Misc'))
)
希望能够帮到你！~

Answer 2

CREATE TABLE Photo
(
PhotoID integer,
Name varchar(30),
Class varchar(30) default 'Unclassified' check (Class in ('Unclassified', 'Nature', 'Family', 'Work', 'Travel', 'Misc'))
)
试试这个，
不太懂 DDL，在百度现学现做的，
还有啊 创建的是表格，不是数据库……