表明test,共有两个字段id,dj,其中id为自增的 把下面语句用查询分析器执行以下,在表中添加dj后id自动增加if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[test] GOCREATE TABLE [dbo].[test] ( [id] [int] IDENTITY (1, 1) NOT NULL , [dj] [float] NULL ) ON [PRIMARY] GO
2.原表数据导入表2(id列除外),
3.删除原表.
4.表2重命名为原表名.
把下面语句用查询分析器执行以下,在表中添加dj后id自动增加if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[test]
GOCREATE TABLE [dbo].[test] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[dj] [float] NULL
) ON [PRIMARY]
GO