Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

changing data type

Hi,

I need to change data type of one of the tables, but the saving keeps timing out.  Any ideas?  thx
0
mcrmg
Asked:
mcrmg
  • 2
1 Solution
 
Rajkumar GsSoftware EngineerCommented:
From which data type to which datatype ?
0
 
mcrmgAuthor Commented:
from varchar(50) to varchar(100), this field is empty, but there are more than 2 M records..thx
0
 
SharathData EngineerCommented:
Post your statement. Are you trying like this?
alter table your_table alter column your_col varchar(100)
0
 
mcrmgAuthor Commented:
I was using design then save...thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now