This is what I do. Makes it easy for me.
At 08:49 AM 7/21/2004, you wrote:
>Warning! : Silly question..
>
>
>
>I use identity fields in MSSql as my primary key. I'm getting ready to
>create a new database and was about to name my primary key field. In the
>past, I've based the name on the table name, ie on table orders, order_id.
>Sometimes that results in some long field names. So, does anyone see a
>downside to naming it a simple "id" or maybe "rowid" or "r_id" or something
>similar?
>
>Marlon
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:5>Todays Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:5:121000>This Message]
>[<http://www.houseoffusion.com/lists.cfm/link=s:5>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=649.569.5>Fast
> Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
>[<https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick>Donations
>and Support]
>
>----------
><http://www.houseoffusion.com/banners/view.cfm?bannerid=38>
>19bc0478.jpg
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
