Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Intermediate
Jul 3, 2001



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Changing Column Types in a Table

Changing column types in a table
SQL Server does not permit you to explicitly change the datatype or length of a column. But there is a trick to get around this. You can use the convert function to redefine the datatypes. For example, if a columnname were defined with a length of 10 and you wanted to change it to length of 100, you would do this:
select convert(varchar(100), columnname) columnname, ...
into DB1..TABLE1
from DB2..TABLE2
Shiv Kumar
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date