create database pubs
use pubs
create table users
(
uid int primary key identity(1000,1),
uname char(10) not null unique,
ups char(10) not null,
gender char(2) check (gender='男' or gender='女') default '男',
age int check (age>15 and age<80),
powers char(10) check(powers='admin' or powers='Guest') default 'Guest'
)
create table news
(
nid int primary key identity,
title char(30) not null,
textt varchar(2000) not null,
jointime datetime,
type char(10) default '其它',
uid char(10) not null foreign key references users(uid)
)
select * from users
select * from news 哪里有错????
use pubs
create table users
(
uid int primary key identity(1000,1),
uname char(10) not null unique,
ups char(10) not null,
gender char(2) check (gender='男' or gender='女') default '男',
age int check (age>15 and age<80),
powers char(10) check(powers='admin' or powers='Guest') default 'Guest'
)
create table news
(
nid int primary key identity,
title char(30) not null,
textt varchar(2000) not null,
jointime datetime,
type char(10) default '其它',
uid char(10) not null foreign key references users(uid)
)
select * from users
select * from news 哪里有错????
(
nid int primary key identity,
title char(30) not null,
textt varchar(2000) not null,
jointime datetime,
type char(10) default '其它',
uid char(10) not null foreign key references users(uid)
)
uid char(10) not null foreign key references users(uid)
~~~~~~~改为int