Question: I need to delete a schema in my PostgreSQL database. I would like to make sure that the schema is not used in another schema (for instance : this schema is used for a view in another one). Is there a way to list all the dependencies in the rest of the database ?

I have tried `DROP SCHEMA mySchema ;` but the given list of dependencies is partial...

Many thanks for help !

Answer: 
SQL Server service account don't have permission in the drive you are using to create database.Don't put you database in the root of drive. It would be problematic if you have UAC enabled, Create a folder in drive. Like `D:\Data`

Check this <http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85).aspx>

```

ERROR_ACCESS_DENIED
5 (0x5)
Access is denied.

```

Make sure that the SQL Server Service Account has read/Write permission to the folder where database file is kept or use the instance default folder of Data/Log where it will already have such permissions.
if you have installed your SQL server in your local machine, your name should be having the permission to the folder from which you are trying to retrieve the data file.