下面是SYBASE中DBA执行语句:
(需要先删除表,再重建。)
USE jtsjk
go
EXEC sp_rename 'shijun','shijun_06132002032910000'
go
CREATE TABLE dbo.shijun
(
RT decimal(1,0) NULL
)
LOCK ALLPAGES
go
INSERT INTO dbo.shijun(
RT
)
SELECT
CONVERT(decimal(1,0),RT)
FROM dbo.shijun_06132002032910000
go
(需要先删除表,再重建。)
USE jtsjk
go
EXEC sp_rename 'shijun','shijun_06132002032910000'
go
CREATE TABLE dbo.shijun
(
RT decimal(1,0) NULL
)
LOCK ALLPAGES
go
INSERT INTO dbo.shijun(
RT
)
SELECT
CONVERT(decimal(1,0),RT)
FROM dbo.shijun_06132002032910000
go
具体是怎么样的,你可以试着用SQL Server7提供的Profiler来监视一下当你把一个表的自增长字段去掉,改为另一个数据类型时(在Enterprise Manager中)数据库都发生了些什么动作,以此作为你自己编写脚本的参考..