U can create one constrain to mentain unique records.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of kapilpatil84firebird
Sent: Thursday, January 19, 2006 12:44 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: ??? HELP--> Any Feature to Uniquely Identify
the to identical rows

We Normally provide PRIMARY KEY in every Table.
But Sometimes we forget or for some reason we do not provide primary
key in table.
In that case it is very difficult to delete one of the two duplicate
records

Just an Example:
======================================
DEPT_ID DEPT_NAME
10 CHEMICAL
10 CHEMICAL
10 CHEMICAL
======================================

Here I Entered Three duplicate records my mistake and I want to keep
only One Unique Record, So if would have been Any Feature to Uniquely
Identify the Row I would be able to Delete that row using that UNIQUE
ID as Oracle Supports.


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> Would you mind not writing "??? HELP--> " in every subject line.
> This is a support list, we understand you want help.
>
> > In Oracle we have rowid which gives the unique id for each row
> >
> > Is There any feature in Firebird to get the unique id...
>
> No, not really.
>
> Is there any specific reason why you want to do this?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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