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

Applicable RDBMS

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