Changes to procedures

This section describes all changes and deprecations for the Neo4j procedures per version.

1. Neo4j 4.3

Procedure Change Comment

dbms.procedures()

Deprecated

Replaced by SHOW PROCEDURES.

dbms.functions()

Deprecated

Replaced by SHOW FUNCTIONS.

db.createIndex()

Deprecated

Replaced by OPTIONS of the CREATE INDEX command.

db.createNodeKey()

Enterprise Edition Deprecated

Replaced by OPTIONS of the CREATE CONSTRAINT ... IS NODE KEY command.

db.createUniquePropertyConstraint()

Deprecated

Replaced by OPTIONS of the CREATE CONSTRAINT ... IS UNIQUE command.

db.indexes()

Deprecated

Replaced by SHOW INDEXES.

db.indexDetails()

Deprecated

Replaced by SHOW INDEXES YIELD *.

db.index.fulltext.createNodeIndex()

Deprecated

Replaced by CREATE FULLTEXT INDEX.

db.index.fulltext.createRelationshipIndex()

Deprecated

Replaced by CREATE FULLTEXT INDEX.

db.index.fulltext.drop()

Deprecated

Replaced by DROP INDEX ....

db.constraints()

Deprecated

Replaced by SHOW CONSTRAINTS.

db.schemaStatements()

Deprecated

Replaced by SHOW INDEXES YIELD * and SHOW CONSTRAINTS YIELD *.

2. Neo4j 4.2

Configuration setting Change Comment

dbms.cluster.quarantineDatabase()

Enterprise Edition New

dbms.cluster.readReplicaToggle()

Enterprise Edition New

dbms.scheduler.jobs()

Enterprise Edition New

dbms.scheduler.failedJobs()

Enterprise Edition New

dbms.functions()

Changed

Signature changed.

dbms.killConnections()

Changed

Available also for Community Edition.

dbms.killQueries()

Changed

Available also for Community Edition.

dbms.killQuery()

Changed

Available also for Community Edition.

dbms.killTransaction()

Changed

Available also for Community Edition.

dbms.killTransactions()

Changed

Available also for Community Edition.

dbms.listConnections()

Changed

Available also for Community Edition.

dbms.listTransactions()

Changed

Available also for Community Edition.

db.listLocks()

Changed

Signature changed from db.listLocks() :: (resourceType :: STRING?, resourceId :: INTEGER?, description :: STRING?) to db.listLocks() :: (mode :: STRING?, resourceType :: STRING?, resourceId :: INTEGER?, transactionId :: STRING?).

db.constraints()

Deprecated

Replaced by SHOW CONSTRAINTS.

db.createIndex()

Deprecated

Replaced by CREATE INDEX.

db.createNodeKey()

Enterprise Edition Deprecated

Replaced by CREATE CONSTRAINT ... IS NODE KEY.

db.createUniquePropertyConstraint()

Deprecated

Replaced by CREATE CONSTRAINT ... IS UNIQUE.

db.indexDetails()

Deprecated

Replaced by SHOW INDEXES VERBOSE OUTPUT.

db.indexes()

Deprecated

Replaced by SHOW INDEXES.

db.schemaStatements()

Deprecated

Replaced by SHOW INDEXES VERBOSE OUTPUT and SHOW CONSTRAINTS VERBOSE OUTPUT.

3. Neo4j 4.1

Configuration setting Change Comment

dbms.listPools()

Enterprise Edition New

dbms.upgrade()

New

dbms.upgradeStatus()

New

dbms.cluster.setDefaultDatabase()

Enterprise Edition New

dbms.listQueries()

Enterprise Edition Changed

The queryId procedure format has changed, and no longer includes the database name. For example, mydb-query-123 is now query-123.

db.index.fulltext.queryNodes()

Changed

Skip and limit options added, e.g. {skip: 10, limit: 100}.

db.index.fulltext.queryRelationships()

Changed

Skip and limit options added, e.g. {skip: 10, limit: 100}.

db.constraints()

Changed

Signature changed. Added details field: db.constraints() :: (name :: STRING?, description :: STRING?, details :: STRING?).

dbms.listTransactions()

Enterprise Edition Changed

Signature changed. Added estimatedUsedHeapMemory field: dbms.listTransactions() :: (transactionId :: STRING?, username :: STRING?, metaData :: MAP?, startTime :: STRING?, protocol :: STRING?, clientAddress :: STRING?, requestUri :: STRING?, currentQueryId :: STRING?, currentQuery :: STRING?, activeLockCount :: INTEGER?, status :: STRING?, resourceInformation :: MAP?, elapsedTimeMillis :: INTEGER?, cpuTimeMillis :: INTEGER?, waitTimeMillis :: INTEGER?, idleTimeMillis :: INTEGER?, allocatedBytes :: INTEGER?, allocatedDirectBytes :: INTEGER?, pageHits :: INTEGER?, pageFaults :: INTEGER?, connectionId :: STRING?, initializationStackTrace :: STRING?, database :: STRING?, estimatedUsedHeapMemory :: INTEGER?).

4. Neo4j 4.0

Configuration setting Change Comment

dbms.cluster.overview()

Enterprise Edition New

dbms.cluster.protocols()

Enterprise Edition New

dbms.cluster.role()

Enterprise Edition New

dbms.security.activateUser()

Enterprise Edition Deprecated

Replaced by ALTER USER.

dbms.security.addRoleToUser()

Enterprise Edition Deprecated

Replaced by GRANT ROLE TO USER.

dbms.security.changePassword()

Deprecated

Replaced by ALTER CURRENT USER SET PASSWORD.

dbms.security.changeUserPassword()

Enterprise Edition Deprecated

Replaced by ALTER USER.

dbms.security.createRole()

Enterprise Edition Deprecated

Replaced by CREATE ROLE.

dbms.security.createUser()

Deprecated

Replaced by CREATE USER.

dbms.security.deleteUser()

Deprecated

Replaced by DROP USER.

dbms.security.listRoles()

Enterprise Edition Deprecated

Replaced by SHOW ROLES.

dbms.security.listRolesForUser()

Enterprise Edition Deprecated

Replaced by SHOW USERS.

dbms.security.listUsers()

Deprecated

Replaced by SHOW USERS.

dbms.security.listUsersForRole()

Enterprise Edition Deprecated

Replaced by SHOW ROLES WITH USERS.

dbms.security.removeRoleFromUser()

Enterprise Edition Deprecated

Replaced by REVOKE ROLE FROM USER.

dbms.security.suspendUser()

Enterprise Edition Deprecated

Replaced by ALTER USER.