-- Create a mapping database
CREATE DATABASE ArcMapping;
GO

-- Optionally create a schema
USE ArcMapping
GO
CREATE SCHEMA db1;
GO

-- Create a synonym
CREATE SYNONYM db1.myTable FOR extremely_verbose_database_name_example.dbo.myTable;
GO

-- Or a view
CREATE VIEW db1.MyTable_vw AS
SELECT Something
FROM extremely_verbose_database_name_example.dbo.myTable;