SQL Server Database Schema Fixer

Memulai perbaikan kolom 'id' pada tabel tbl_idrg_icd...

1. Membuat salinan skema tabel...
2. Mengubah nama tabel asli ke tbl_idrg_icd_old...
3. Membuat tabel baru dengan kolom 'id' IDENTITY...
Gagal membuat tabel baru: [Microsoft][ODBC SQL Server Driver][SQL Server]The size (2147483647) given to the column 'description' exceeds the maximum allowed for any data type (8000).
Query:
CREATE TABLE tbl_idrg_icd (
  [id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
  [code] char(100) NOT NULL,
  [code2] char(100) NOT NULL,
  [description] text(2147483647) NOT NULL,
  [system] char(250) NOT NULL,
  [validcode] int NOT NULL,
  [accpdx] char(250) NOT NULL,
  [asterisk] char(250) NOT NULL,
  [im] char(250) NOT NULL,
  [created_at] datetime NOT NULL,
  [updated_at] datetime NOT NULL,
  [deleted_at] datetime NOT NULL
)