Hi, we have bunch of Schemas in our production databases (SQL 2005). The problem is that most of the schemas have very long name. So every time we run a SQL statement we have to type the name of the schema where the table resides. "PublicfacingHouse.Clients" I don't really want to rename the schema. But is there a way to create a link or Alias with much shorter name.
Schema Name: PublicFacingHouse.Clients
Alias name would be like PH.Clients