Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

INFORMATION_SCHEMA.COLUMNS <> Table Definition Expand / Collapse
Author
Message
Posted Monday, June 23, 2008 1:04 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:59 PM
Points: 2,705, Visits: 3,773
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 you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Post #522139
Posted Monday, June 23, 2008 1:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:59 PM
Points: 2,705, Visits: 3,773
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 you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Post #522142
Posted Monday, June 23, 2008 7:38 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Bug?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #522292
Posted Monday, June 23, 2008 9:53 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, January 2, 2014 10:30 AM
Points: 646, Visits: 731
did you check filter by table_schema in information_Schema.columns.

Maninder
www.dbanation.com
Post #522312
Posted Tuesday, June 24, 2008 7:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:59 PM
Points: 2,705, Visits: 3,773
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 you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Post #522511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse