RE: Rowids in Informix Databases

Vijay All the tables will have rowids (they must !!), they are not visible on a normal table view but can be returned by query. If a table is fragmented (but only if (v7.31) ) it can be created WITH ROWIDS which will create a separate rowid column. Why do you need rowids? They tend to be a fudge to cover up poor or inadequate database design. Don't you have lots of lovely, simple (single column) primary keys to use to identify your records. Keith=20 -> -----Original Message----- -> From: Vijay Kumar [mailto:rudrappa@india.hp.com] -> Sent: Tuesday, October 12, 2004 12:33 PM -> To: informix-list@iiug.org -> Subject: Rowids in Informix Databases ->=20 ->=20 -> Hi All, ->=20 -> We have created a database in informix 9.40 on HP=20 -> Itanium machine. -> The tables doesn't have rowid column. Is there way to create=20 -> the database -> such that all the tables have rowid column? Please let me=20 -> know regarding -> this. Thanks in advance. ->=20 -> Regards, -> Vijay Kumar ->=20 -> sending to informix-list ->=20 ***************************************************************************= ******* This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ***************************************************************************= ******* sending to informix-list