Example: My table structure is like that: create table mytablename(id bigint,name varchar(50),age int,address varchar(500)) Now i want to change the datatype of age column of above created table.then i write this query: alter table mytablename alter column age varchar(30) Then datatype og age column changed from int to varchar(30)

Answer

how to modify column data type in table

vivek upadhyay

11y

980

with example

Answers (1)

Next Recommended Forum

HOW TO DROP PRIMARY KEY CONTRAINS FROM CUSTOMER TABLE

normal form in sql server

Leaderboard

View all

Tuhin Paul

John Godel

Dashrath Hapani

View all

Yesterday's leader

Tuhin Paul

India

302.2k

29.1k

100

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

706

10.1k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

158

118.1k

11.9k

500

Upcoming events

View all

Suggested for you

View all

Magnus Mårtensson

Allam Purushotham

Sangeetha S

Ankit Rai

Gowtham K

Forum Statistics

Please welcome our newest member Jonathan Forrider.
3,078,601 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 11 new threads, 29 new posts, and 64 new users.
In last week, the most popular thread is 'Get 24 months rollover value from database'.