Member Avatar for waqar100

I want to increase the data type of varchar(100) to varchar(200)?without any loss of data in the existing table?HOW

  • 4 Contributors
  • 3 Replies
  • 269 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by crishlay
Member Avatar for kvprajapati

Use ALTER TABLE statement.

Member Avatar for pinkygirl

do you want to do that in sql or asp.net?

Member Avatar for crishlay

I want to increase the data type of varchar(100) to varchar(200)?without any loss of data in the existing table?HOW

ALTER TABLE table_name
MODIFY COLUMN col_name varchar(200)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.