I can't find a way in the product. Would you consider adding this? It would be tremendously useful. I sometimes need to copy very long SQL scripts from an existing system in which a default schema is assumed. Right now I need to trawl through all the coding, prefixing every table and column reference to include the schema name. Would be so much easier if I could set a default schema name for a connection - even for all connections, cos I always use the same schema.
Please sign in to leave a comment.