The real problem that I’m trying to solve is to allow 3rd party ODBC connections, and end-users to access my database via SQL: when every table in my database has an object field.
I’ve come to realize that every SQL tool in the world that I have tried seems to crash, or error out, when looking at a table that has any Object fields.
So: to try to overcome this: I’m attempting to make an SQL Schema in my database that has VIEWs that are exact copies of my tables, but exclude any Object fields. I’ve succeeded at doing this: but I’d like to create a Schema that has ONLY my VIEWS, and NOT the actual tables themselves.
Is there a way to REMOVE a table from a SCHEMA?
Or, is there some better solution to my problem with how outside technologies freak out when seeing an object field?