Gossamer Forum: Products: DBMan SQL: Discussion: Re: [jean] Search (jai)

Gossamer Threads

Home : Products : DBMan SQL : Discussion :

Re: [jean] Search

Apr 11, 2002, 10:29 PM

jai

User (417 posts)

Apr 11, 2002, 10:29 PM

Shortcut

Re: [jean] Search In reply to

Jean,

After running the SQL query (using MySQLMan) ALTER TABLE contact ADD FOREIGN KEY (Username) REFERENCES users(Username); should I get a message to say it has been set or should the field appear as unique?? How can we tell if the Foreign Key has been set??

Thank you.

Simon.

Subject	Author	Views	Date
Search	jai	6753	Mar 17, 2002, 4:16 AM

Re: [jai] Search	jean	6577	Mar 17, 2002, 9:49 PM

Re: [jean] Search	jai	6565	Mar 18, 2002, 6:35 AM

Re: [jai] Search	jean	6568	Mar 18, 2002, 11:07 AM

Re: [jean] Search	jai	6557	Mar 18, 2002, 8:42 PM

Re: [jai] Search	jean	6532	Mar 20, 2002, 11:06 PM

Re: [jean] Search	jai	6517	Mar 21, 2002, 5:59 AM

Re: [jean] Search	jai	6519	Mar 22, 2002, 5:18 AM

Re: [jai] Search	jean	6520	Mar 22, 2002, 9:17 AM

Re: [jean] Search	jai	6505	Mar 22, 2002, 3:24 PM

Re: [jai] Search	jai	6490	Apr 11, 2002, 4:39 PM

Re: [jai] Search	jean	6464	Apr 11, 2002, 5:12 PM

Re: [jean] Search	jai	6492	Apr 11, 2002, 10:29 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676