Example: My table structure is like that: create table mytablename(id bigintname varchar(50)age intaddress 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

10y

699

with example

Answers (1)

Next Recommended Forum

HOW TO DROP PRIMARY KEY CONTRAINS FROM CUSTOMER TABLE

normal form in sql server

Leaderboard

View all

Deepak Tewatia

Aryan Kumar

Jemmy Jackson James

View all

Yesterday's leader

Deepak Tewatia

C#, Asp.net, DB, F#, AI, MVC

India

18.9k

16.8k

Member of the month

Rinki

Chennai (India)

6.1k

14.2k

Speaker of the month

Shivam Payasi

C#, .NET

Chitrakoot (India)

22.4k

20.2k

Upcoming events

View all

Bhubaneswar Chapter
Building Websites with Microsoft Power Pages: Exploring WebPage, WebTemplate, and Page Templates - Microsoft Business Application Ep. 25

Suggested for you

View all

Manish Tewatia

Nilesh Jadav

James Tomar

Gaurav Kumar Singh

Mahesh Chand

Forum Statistics

Please welcome our newest member Harshit .
2,380,772 users have contributed to 122,526 threads and 389,013
In the past 24 hours, we have 18 new threads, 37 new posts, and 1 new users.
In last week, the most popular thread is 'why a good project structure is important'.