I wanted to know if/how I can create a schema alias that references another schema name such that I can get tables from the original schema alias. The reason I ask is that I have a SS2K DB that is case-sensitive. But I need to do insensitive queries against it. So I was hoping there was a way to create an uppercase schema name that can be used to get a list of tables from the original case-sensitive schema name.
If I have a schema called dbo, such that select * from dbo.USERTABLE returns a list of columns
I want to be able to create another schema called DBO such that select * from DBO.USERTABLE will return the same result.
I've spent two days straight trying to come up with something, so any and all help would be greatly appreciated.
I need to get this done, so if there are other possibilities to accomplish this, I am open to suggestions.
Thanks in advance.