如何更改SQL Server中数据库表上的TEXT列？

您可以使用企业管理器来创建脚本。右键单击EM中的表，然后选择“设计”。取消选中文本字段的允许空列。不用单击常规的保存图标（软盘），而是单击看起来像带有小软盘的金色滚动图标，或者从菜单中执行“表设计器”>“生成更改脚本”。将脚本保存到文件中，以便您可以重复使用它。这是一个示例脚本：

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
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
GO
CREATE TABLE dbo.Tmp_TestTable
   (
   tableKey int NOT NULL,
   Description varchar(50) NOT NULL,
   TextData text NOT NULL
   )  ON [PRIMARY]
    TEXTIMAGE_ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.TestTable)
    EXEC('INSERT INTO dbo.Tmp_TestTable (tableKey, Description, TextData)
       SELECT tableKey, Description, TextData FROM dbo.TestTable WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.TestTable
GO
EXECUTE sp_rename N'dbo.Tmp_TestTable', N'TestTable', 'OBJECT' 
GO
ALTER TABLE dbo.TestTable ADD CONSTRAINT
   PK_TestTable PRIMARY KEY CLUSTERED 
   (
   tableKey
   ) ON [PRIMARY]

GO
COMMIT