We have several layers that appear to be in the sql database but not visible in Catalog. I have tried importing a layer in with the same name into the database but it gives me the "layer already exists" error. I have also been able to do an export of a portion of the database to my desktop and layer shows up in the exported database. It simply appears that Catalog just isn't displaying all layers.
I'm not sure where to go from here. We need the layers to appear. Would it be best to delete the layers on the SQL end and import a copy back in? We are not super SQL savvy so we would prefer not to do this.