asp的数据库设计的问题
来源:百度知道 编辑:UC知道 时间:2024/06/25 13:09:13
alter table REPLY
drop constraint FK_REPLY_REFERENCE_TOPIC
go
if exists (select 1
from sysobjects
where id = object_id('Topic')
and type = 'U')
drop table Topic
go
/*==============================================================*/
/* Table: Topic */
/*==============================================================*/
create table Topic (
TOPICID int not null,
TOPICTITLE varchar(100) null,
TOPICAUTHOR varchar(50) null,
TOPICDATE datetime null,
TOPICCONTENT varchar(8000) null,
REMARK varchar(200) null,
constraint PK_TOPIC primary key (TOPICID)
)
go
alter table REPLY
drop constraint FK_REPLY_REFERENCE_