Question about converting bigint field to int field
- From: mamorgan1@xxxxxxxxx
- Date: 20 Jan 2006 06:52:55 -0800
We made a poor decision a long time ago when designing our database
structure. We used bigint data types as the identity keys for many of
our base tables. For many reasons I would like to change these fields
to int at the largest. The largest data in these fields is around
200,000. I know that int can easily store this.
What should I be worried about when changing these fields from bigint
to int? If anything. Your help is appreciated. I did several
searches without much luck.
.
- Follow-Ups:
- Re: Question about converting bigint field to int field
- From: Tony Rogerson
- Re: Question about converting bigint field to int field
- Prev by Date: Re: Advanced Data Shaping - Multiple Relate clause
- Next by Date: Re: Question about converting bigint field to int field
- Previous by thread: Link to DB2
- Next by thread: Re: Question about converting bigint field to int field
- Index(es):