top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How can we change the data type of a column of a table in SQL?

+2 votes
68 views
How can we change the data type of a column of a table in SQL?
posted Mar 13, 2015 by Amit Kumar Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes

alter table TableName
alter column ColumnName nvarchar(200) [null | not null]

answer Mar 13, 2015 by Tanmoy Debnath
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...