CREATE TABLE [dbo].[BTU_MISReport](
[BusinessDate] [date] NULL,
[BRANCH_NAME] [nvarchar](max) NULL,
[BR_CODE] [nvarchar](50) NULL,
[Name_of_Valuer] [nvarchar](150) NOT NULL,
[ADDRESS] [int] NULL,
[LIST_OF_BR] [nvarchar](max) NULL,
[Score_Grade] [int] NULL,
[GoldSmith_PROP_NAME] [nvarchar](150) NOT NULL,
[Authorized_Signatory1] [int] NULL,
[Authorization_Date1] [int] NULL,
[Authorized_Signatory2] [int] NULL,
[Authorization_Date2] [int] NULL,
[Authorized_Signatory3] [int] NULL,
[Authorization_Date3] [int] NULL,
[FinalStatus] [int] NULL,
[Acknowledgement] [int] NULL,
[Date_of_HandinG] [int] NULL,
[Remarks_Anomalies] [int] NULL,
[Receiving_Date] [int] NULL,
[Intimation] [int] NULL,
[AgreementDate] [date] NULL,
[AgreementExpiryDate] [date] NULL,
[CancelledAgreement] [int] NULL,
[AgreementCancelIntimationDate] [int] NULL,
[Comments] [int] NULL,
[Reason] [int] NULL,
[Agreement] [varchar](17) NOT NULL,
[STATUS] [nvarchar](50) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
What I have tried:
I need to alter this table but also want to alter the columns datatypes for example
[ADDRESS] [int] NULL, to [ADDRESS] [nvarchar] (Max) NULL,
Please help me out in this matter.