Displaying tables/views in a folder
I'd like to display some objects in "folders" for users so they can easily be found. Basically the server layout of the objects does not match what I'd like to display to the user.
I've tried using Packages for this purpose, but this affects the NameFull property.
E.g. I have a view called MyView in a schema MySchema.
The query name for this should be:
But if I put it in MyPackage1->MyPackage2 (nested packages) the full name is
Is there a way to override the NameFull so that the layout of the object tree doesn't match the namespaces of the objects? Or is there something else I could do?
(Hope that makes sense!)