使用MSSQL2000,下面是表的脚本 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Student]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Student] GO CREATE TABLE [dbo].[Student] ( [id] [int] IDENTITY (1, 1) NOT NULL , [username] [varchar] (200) COLLA