Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Other Syntax Segments > Specific Name >

Restrictions on the Specific Name

In a database that is not ANSI-compliant, specific_id must be unique among routine names within the database. Two UDRs cannot have the same specific_id, even if they have different owners.

In an ANSI-compliant database, the combination owner.specific_id must be unique. That is, the specific name must be unique among UDRs that have the same owner.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]