How to remove Labels without Nodes?

Neo4j Graph Platform Cypher
1

removed all Nodes/RelationShips with "detach delete"
now Desktop keeps on showing my original Labels on Database Information, although no Nodes exist
how to get rid of them other than scratching the database ?
Alex
ps apoc.meta.schema() shows the labels, apoc.meta.graph() and apoc.meta.data() does not

2

Hi Alex,

Perhaps you still have an index or constraint on those label(s). In that case the Label would still show up.

David

3

Hi David, that solved it
thought (wrongly) that the detach delete of all nodes would equate to some drop table
Thx, Alex

4

follow up on Property's
call db.propertyKeys() keep showing property's that no longer exist in the database (deleted all constraints, indexes and nodes)
so how to get rid of them ?
Alex

5

@alex.meyers the underlying metadata in Neo4j does not record a counter of number of nodes per property key and as such even if you delete all nodes/relationships there is no way to then remove propertyKeys()... well of course you could create a new database

1 Like
6

I shoulda anticipated that next question :grinning:

7

no problem :)
coming over from relational world and just learning