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
  • 191 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by crishlay

Recommended Answers

All 3 Replies

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.