June 23, 2008 at 1:04 pm
I have a table that has one particular column of VARCHAR datatype. The entry in INFORMATION_SCHEMA.COLUMNS says it's a FLOAT.
Right Click > Script Object as CREATE also returns a VARCHAR.
Table in Design View is also VARCHAR.
Any ideas on how to fix or why/how this happened?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2008 at 1:07 pm
GOT IT.
Changed the datatype from VARCHAR(7) to VARCHAR(8) and back again.
But still unsure how this could happen?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2008 at 7:38 pm
Bug?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 23, 2008 at 9:53 pm
did you check filter by table_schema in information_Schema.columns.
Maninder
www.dbanation.com
June 24, 2008 at 7:08 am
Mani Singh (6/23/2008)
did you check filter by table_schema in information_Schema.columns.
That's where it said FLOAT.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply