Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Statistics error trying to alter column

Status
Not open for further replies.
EugenePaliev

EugenePaliev

Programmer
Jul 18, 2001
537
UA
Hello,

I'm trying to change data type of the column ZIP from INT to CHAR(10) and got this error "The statistics 'ZIP' is dependent on column 'ZIP'". This error appears all the time I want to make changes to any column of this table. Making changes to other tables is OK.

What can I do to make changes to the column?

Thanks in advance! Good Luck! :)
 
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
1K
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
2K
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top