Hello Alexandre Of course that no with people's names, just with control tables like Countries or States which never have duplicates.
Greetings. Walter. On Sun, Aug 14, 2011 at 11:03 PM, Alexandre Benson Smith < [email protected]> wrote: > ** > > > Em 14/8/2011 23:43, W O escreveu: > > > Hello everybody > > > > I had unique key restrictions on the column "Name" of tables like: > > Countries, States, Banks, etc. > > > > So, I can avoid duplicates. > > > > What do you think, is it correct to use unique keys for that job? > > > > Greetings. > > > > Walter. > > > > It depends on the business rules... > > I don't think that a unique constraint on the Field Name of a table of > people is ok. > > We al lknow that there is more than one John Smith in the world. > > see you ! > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
