Short answer:

Yes, and not generally but it depends on what you are trying to
accomplish.

Why don't you use surrogate keys? Composite primaries, without further
qualification, are often a sign of trouble to come.

On Sun, 2005-07-17 at 03:29 +0000, women_lover_best wrote:
> Hi,
>
> I have situation like this..I have table with 2 foriegn keys..and I
> want to make them part of primary key(composite) in the same table.is
> it possible in firebird?If yes,is it a good practice?..
> thanks
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>