databaseid

Databaseid, or database identifier, is a unique value assigned to a database within a server, instance, or managed environment. It serves as a stable reference that software and administrators use to locate, catalog, and operate on the database among many databases.

Most implementations represent the identifier as a numeric value or a globally unique identifier, and it is typically immutable after creation. The databaseid is distinct from the database’s human-readable name, which can change; the id remains constant even if the database is renamed.

Common uses include catalog queries, backup and restore operations, replication, auditing, and access control. Applications and administrative tools pass the databaseid to identify the target database when issuing operations or when exporting metadata.

System-specific notes: In Microsoft SQL Server, the database_id is an integer shown in system catalogs (for example, master has database_id 1). In PostgreSQL, the equivalent is the database's OID stored in pg_database. Other systems may expose the concept under a different name, such as DBID, or may not expose a persistent numeric id at all, relying instead on names and paths.

Security and governance: Access to the databaseid should be restricted to privileged users, as it can reveal topology and facilitate reconnaissance. Logging and auditing may record actions by databaseid to maintain an auditable trail.

See also: database, database management system, OID, GUID, schema.