Delete Node my esitcing Node labes

Hi ,

I can see still my node labels even after deletion of my existing nodes please help someone please .refer attched screenshot how to clear all these node

simsree9_0-1657695511999.png

I didn't create any indexes & constraints , please share the steps to reset all node labels

Hello @simsree9 :slightly_smiling_face:

It means you have constraints or indexes, you can see them with SHOW INDEXES and SHOW CONSTRAINTS. Here are the queries if you want to delete them:

// Drop an index
DROP INDEX constraint_name IF EXISTS
// Drop a constraint
DROP CONSTRAINT constraint_name IF EXISTS
// You can also use APOC to drop all indexes and constraints in one query
CALL apoc.schema.assert({}, {}, true);

Regards,
Cobra

1 Like

Look at my previous post, you have all the queries... You can also use this query in the system database:

// Reset the whole database
CREATE OR REPLACE DATABASE database_name

Thanks, @cobra best answer!!