|
|
|
OBJECT_ID function (extension)
Syntax
OBJECT_ID ('table_name')
Description
The scalar function OBJECT_ID returns the value of the id column in the admin.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 admin.systables
1 where owner = 'admin';
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
.
.
.
