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

997

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 Rishabh anand.
3,084,236 users have contributed to 147,418 threads and 483,478
In the past 24 hours, we have 2 new threads, 10 new posts, and 95 new users.
In last week, the most popular thread is 'How to "C# Corner"'.

Upcoming Events

View all

Software Architecture Conference - 2025