SQL Queries - CAST Knowledge Base - Queries on objects - How to get the ID of an object from its object name or full name

Purpose of Query

This document provides a query to get the ID of an object from its name, and a query to get the ID of an object from its full-name.

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS

Query for CSS

--  From its name
SELECT IDKEY
FROM         KEYS
WHERE  KEYNAM = '<OBJECT_NAME>'
 
-- From its full-name
SELECT IDOBJ
FROM               OBJFULNAM
WHERE  FULLNAME = '<OBJECT_FULL_NAME>'

Query result example

1146643

Query result interpretation

The ID of the object in Knowledge Base us 1146643

Query for Oracle

--  From its name
SELECT IDKEY
FROM         KEYS
WHERE  KEYNAM = '<OBJECT_NAME>'


-- From its full-name
SELECT IDOBJ
FROM               OBJFULNAM
WHERE  FULLNAME = '<OBJECT_FULL_NAME>'

Query result example

1146643

Query result interpretation

The ID of the object in Knowledge Base us 1146643

Query for SQL server

--  From its name
SELECT IDKEY
FROM         KEYS
WHERE  KEYNAM = '<OBJECT_NAME>'


-- From its full-name
SELECT IDOBJ
FROM               OBJFULNAM
WHERE  FULLNAME = '<OBJECT_FULL_NAME>'

Query result example

1146643

Query result interpretation

The ID of the object in Knowledge Base us 1146643

Notes/comments

Related Pages