Changes to procedures

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

1. Neo4j 4.4

Name Community Edition Enterprise Edition Comment

dbms.killQueries()

Yes

Yes

Deprecated Replaced by TERMINATE TRANSACTIONS.

dbms.killQuery()

Yes

Yes

Deprecated Replaced by TERMINATE TRANSACTIONS.

dbms.killTransaction()

Yes

Yes

Deprecated Replaced by TERMINATE TRANSACTIONS.

dbms.killTransactions()

Yes

Yes

Deprecated Replaced by TERMINATE TRANSACTIONS.

dbms.listQueries()

Yes

Yes

Deprecated Replaced by SHOW TRANSACTIONS.

dbms.listTransactions()

Yes

Yes

Deprecated Replaced by SHOW TRANSACTIONS.

2. Neo4j 4.3

Name Community Edition Enterprise Edition Comment

dbms.procedures()

Yes

Yes

Deprecated Replaced by SHOW PROCEDURES.

dbms.functions()

Yes

Yes

Deprecated Replaced by SHOW FUNCTIONS.

db.createIndex()

Yes

Yes

Deprecated Replaced by OPTIONS of the CREATE INDEX command.
To be removed in 5.0.

db.createNodeKey()

No

Yes

Deprecated Replaced by OPTIONS of the CREATE CONSTRAINT ... IS NODE KEY command.
To be removed in 5.0.

db.createUniquePropertyConstraint()

Yes

Yes

Deprecated Replaced by OPTIONS of the CREATE CONSTRAINT ... IS UNIQUE command.
To be removed in 5.0.

db.indexes()

Yes

Yes

Deprecated Replaced by SHOW INDEXES.
To be removed in 5.0.

db.indexDetails()

Yes

Yes

Deprecated Replaced by SHOW INDEXES YIELD *.
To be removed in 5.0.

db.index.fulltext.createNodeIndex()

Yes

Yes

Deprecated Replaced by CREATE FULLTEXT INDEX.

db.index.fulltext.createRelationshipIndex()

Yes

Yes

Deprecated Replaced by CREATE FULLTEXT INDEX.

db.index.fulltext.drop()

Yes

Yes

Deprecated Replaced by DROP INDEX ....

db.constraints()

Yes

Yes

Deprecated Replaced by SHOW CONSTRAINTS.
To be removed in 5.0.

db.schemaStatements()

Yes

Yes

Deprecated Replaced by SHOW INDEXES YIELD * and SHOW CONSTRAINTS YIELD *.
To be removed in 5.0.

3. Neo4j 4.2

Name Community Edition Enterprise Edition Comment

dbms.cluster.quarantineDatabase()

No

Yes

New

dbms.cluster.readReplicaToggle()

No

Yes

New

dbms.scheduler.jobs()

No

Yes

New

dbms.scheduler.failedJobs()

No

Yes

New

dbms.functions()

No

Yes

Changed Signature changed.

dbms.killConnections()

Yes

Yes

Changed Available also for Community Edition.

dbms.killQueries()

Yes

Yes

Changed Available also for Community Edition.

dbms.killQuery()

Yes

Yes

Changed Available also for Community Edition.

dbms.killTransaction()

Yes

Yes

Changed Available also for Community Edition.

dbms.killTransactions()

Yes

Yes

Changed Available also for Community Edition.

dbms.listConnections()

Yes

Yes

Changed Available also for Community Edition.

dbms.listTransactions()

Yes

Yes

Changed Available also for Community Edition.

db.listLocks()

Yes

Yes

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

db.constraints()

Yes

Yes

Deprecated Replaced by SHOW CONSTRAINTS.

db.createIndex()

Yes

Yes

Deprecated Replaced by CREATE INDEX.

db.createNodeKey()

No

Yes

Deprecated Replaced by CREATE CONSTRAINT ... IS NODE KEY.

db.createUniquePropertyConstraint()

Yes

Yes

Deprecated Replaced by CREATE CONSTRAINT ... IS UNIQUE.

db.indexDetails()

Yes

Yes

Deprecated Replaced by SHOW INDEXES VERBOSE OUTPUT.

db.indexes()

Yes

Yes

Deprecated Replaced by SHOW INDEXES.

db.schemaStatements()

Yes

Yes

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

4. Neo4j 4.1

Name Community Edition Enterprise Edition Comment

dbms.listPools()

No

Yes

New

dbms.upgrade()

Yes

Yes

New

dbms.upgradeStatus()

Yes

Yes

New

dbms.cluster.setDefaultDatabase()

No

Yes

New

dbms.listQueries()

No

Yes

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()

Yes

Yes

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

db.index.fulltext.queryRelationships()

Yes

Yes

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

db.constraints()

Yes

Yes

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

dbms.listTransactions()

No

Yes

Changed Signature changed. Added an 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?).

5. Neo4j 4.0

Name Community Edition Enterprise Edition Comment

dbms.cluster.overview()

No

Yes

New

dbms.cluster.protocols()

No

Yes

New

dbms.cluster.role()

No

Yes

New

dbms.security.changePassword()

Yes

Yes

Deprecated Replaced by ALTER CURRENT USER SET PASSWORD.

dbms.security.activateUser()

No

Yes

Deprecated Replaced by ALTER USER.

dbms.security.addRoleToUser()

No

Yes

Deprecated Replaced by GRANT ROLE TO USER.

dbms.security.changePassword()

Yes

Yes

Deprecated Replaced by ALTER CURRENT USER SET PASSWORD.

dbms.security.changeUserPassword()

No

Yes

Deprecated Replaced by ALTER USER.

dbms.security.createRole()

No

Yes

Deprecated Replaced by CREATE ROLE.

dbms.security.createUser()

Yes

Yes

Deprecated Replaced by CREATE USER.

dbms.security.deleteUser()

Yes

Yes

Deprecated Replaced by DROP USER.

dbms.security.listRoles()

No

Yes

Deprecated Replaced by SHOW ROLES.

dbms.security.listRolesForUser()

No

Yes

Deprecated Replaced by SHOW USERS.

dbms.security.listUsers()

Yes

Yes

Deprecated Replaced by SHOW USERS.

dbms.security.listUsersForRole()

No

Yes

Deprecated Replaced by SHOW ROLES WITH USERS.

dbms.security.removeRoleFromUser()

No

Yes

Deprecated Replaced by REVOKE ROLE FROM USER.

dbms.security.suspendUser()

No

Yes

Deprecated Replaced by ALTER USER.