If you want to find book entries that have no associated ebook format then you can search using
You can then decide if you want to remove the identified book entries from the Calibre database.
As was mentioned many people (myself included) use book entries with no attached ebook format for purposes such as wish list entries and tracking paper/audio books so there is no way Calibre should ever not allow this scenario.