How to alter this type of table

Question

1.00/5 (1 vote)

See more:

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.

Posted 26-Jul-18 0:51am

Member 13926583

Updated 26-Jul-18 1:11am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-07-26T01:11:00

Solution 1

SQL

ALTER TABLE MyTable
ALTER COLUMN ColumnName NVARCHAR(MAX);

A quick google would have found you that... SQL ALTER TABLE Statement[^]

Posted 26-Jul-18 1:11am

OriginalGriff

Comments

Member 13926583 26-Jul-18 7:14am

But its giving Syntax Error near [BusinessDate] [date] NULL,
whats the issue??

OriginalGriff 26-Jul-18 7:22am

How do I know - I can't see the ALTER code you tried to use...

Naga Sindhura 1-Aug-18 3:31am

check for other constraints exists in BTU_MISReport table. because above solution perfectly works for altering a table column datatype as follows
ALTER TABLE BTU_MISReport
ALTER COLUMN ADDRESS NVARCHAR(MAX);

syntax errors will always points to staring line of the code base. check-it once again.