This ability depends upon your permissions and backend database, as you would need to inspect the 'data dictionary' views belonging to your database provider (e.g. USER_VIEWS and USER_OBJECTS and USER_SOURCE in Oracle).
As a generic database question (i.e. it applies to any product that sits on the database, not PPM specific), you can Google for the method that applies to your infrastructure and take up answers that have been used elsewhere.