I have schema's in my database which i think we are not using them anymore. We have 100's of them in each database. Before dropping them how can i check their dependencies, whether they are associated with any table/user or anything?
Any help would be much appreciated
You should be able to query that using some of the system tables:
You might have to adjust for your particular environment but this would give you list of schema's that do not have any objects tied to it.
Hope that helps!
answered Aug 11 at 01:52 PM