alter TABLE 你的表名
ALTER COLUMN 要修改的字段名 新的字段类型和长度 一个例子:
表名:table1
字段名:Content
原字段类型 :nvachar(2000) 不允许为空
新字段类型 :nvachar(3000) 不允许为空alter TABLE table1
ALTER COLUMN Content nvarchar(3000) NOT NULL
ALTER COLUMN 要修改的字段名 新的字段类型和长度 一个例子:
表名:table1
字段名:Content
原字段类型 :nvachar(2000) 不允许为空
新字段类型 :nvachar(3000) 不允许为空alter TABLE table1
ALTER COLUMN Content nvarchar(3000) NOT NULL
modified( Content nvarchar2(3000) NOT NULL )
不过还是谢谢二位了,容我先试试!定会给分的!
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_Bricks
(
BrickPartNmbr int NOT NULL,
BrickColor nchar(30) NULL,
BrickHeight decimal(4, 1) NULL,
BrickLength decimal(4, 1) NULL,
BrickWidth decimal(4, 1) NULL,
BrickVolume AS ([dbo].[CubicVolume]([BrickHeight], [BrickLength], [BrickWidth]))
) ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.Bricks)
EXEC('INSERT INTO dbo.Tmp_Bricks (BrickPartNmbr, BrickColor, BrickHeight, BrickLength, BrickWidth)
SELECT BrickPartNmbr, BrickColor, BrickHeight, BrickLength, BrickWidth FROM dbo.Bricks TABLOCKX')
GO
DROP TABLE dbo.Bricks
GO
EXECUTE sp_rename N'dbo.Tmp_Bricks', N'Bricks', 'OBJECT'
GO
ALTER TABLE dbo.Bricks ADD CONSTRAINT
PK_Bricks PRIMARY KEY NONCLUSTERED
(
BrickPartNmbr
) ON [PRIMARY]GO
COMMIT