4.9.2.58 OBJECT_ID function (extension)

Syntax

OBJECT_ID ('table_name')

Description

The scalar function OBJECT_ID returns the value of the id column in the systpe.systables, plus one. This function provides compatibility with the Sybase SQL Server function object_id.

Arguments

table_name

The name of the table for which OBJECT_ID returns an identification value.

Example

select id, object_id(tbl), tbl from systpe.systables
   1  where owner = 'systpe';
          ID OBJECT_ID(TB TBL
          -- ------------ ---
           0            1 systblspaces
           1            2 systables
           2            3 syscolumns
           3            4 sysindexes
           4            5 systsfiles
           5            6 syslogfiles
           6            7 sysdbbackup
           7            8 syslogbackup
           8            9 sysdbsyncpt
           9           10 sysdbsuuid
          10           11 syssyssvr
          11           12 sysusrsvr
.
.
.