>On 1/16/07, Nick G <[EMAIL PROTECTED]> wrote: >> >> I hope this is not a newbie question...I'm not much of a DB person. I need >> to update or modify a table to make two fields to be unique (empnumid and >> solnum). The empnumid is the primary key and there is no foriegn key. Thanks >> for taking a look! > > >An unique index would work if I understand the question correctly. > >Just a point of reference though, I know empnumid means something to you, >but you might be better off being a little more explicit with your table >definition. It makes your db structure easier to remember and understand >for years to come. employee_id (assuming that empnumid is employee >something or other;) makes more sense when you are looking at it than >empnumid. Although, maybe that's just my own way of looking at things.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2678 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
