if exists (select * from sysobjects where id = object_id(N'pic') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table pic
GO
if exists (select * from sysobjects where id = object_id(N'pic_master') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table pic_master
GO
CREATE TABLE pic (
id char (10) NOT NULL ,
sequence int NOT NULL ,
type char (10) NULL ,
pic image NULL
)
GO
CREATE TABLE pic_master (
id char (10) NOT NULL
)
GO
ALTER TABLE pic WITH NOCHECK ADD
CONSTRAINT PK_pic PRIMARY KEY CLUSTERED
(
id,
sequence
)
GO
ALTER TABLE pic_master WITH NOCHECK ADD
CONSTRAINT PK_pic_master PRIMARY KEY CLUSTERED
(
id
)
GO
- 1
- 2
- 3
- 4
- 5
- 6
前往页