MS SQL7.0中 创建表和删除表怎么写？(10分)

我想在MS SQL7.0中创建表和删除表，怎么写？

用create和drop

CREATE TABLE jobs
(
job_id smallint
IDENTITY(1,1)
PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL
DEFAULT 'New Position - title not formalized yet',
min_lvl tinyint NOT NULL
CHECK (min_lvl >= 10),
max_lvl tinyint NOT NULL
CHECK (max_lvl <= 250)



DROP TABLE jobs

谢谢两位，分不多，仅表心意！