Hi everyone,

I was wondering how to determine the datatype of my table. For example, I have a Operator table, which datatype should I use for OperatorID?

Thank you in advance.
Sherry

How would you like to identify your Operators? Should the OperatorID be a string value like a user name? Or is this field something that should be generated by the database?

if u ask me I'd rather to use SMALLINT but if u think ur range need more use INT or even BIGINT.
HTH.

Always:),
Hovik Melkomian.

What's an 'OperatorID'? What does it describe? The datatype for any attribute should be that type which is necessary and sufficient to completely represent that which the attribute describes.

Your question is like asking me what color paint you should buy. I can't possibly answer that question without knowing what you intend to do with it.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com