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

with example

Answers (1)

Next Recommended Forum

HOW TO DROP PRIMARY KEY CONTRAINS FROM CUSTOMER TABLE

normal form in sql server

Forum Statistics

Please welcome our newest member Rajasekar MP.
3,090,285 users have contributed to 147,410 threads and 483,573
In the past 24 hours, we have 2 new threads, 19 new posts, and 130 new users.
In last week, the most popular thread is 'Will LOV111VOL replace SharePoint worldwide?'.

Upcoming Events

View all

Advancing into the Future with IT
Live Discussion on Startups, AI, and Career Growth
Github Copilot Global Bootcamp - 2025