MyDb.dbo.Festivals
MyDb.India.Festivals
MyDb.China.Festivals
MyDb.USA.Festivals

CREATE FUNCTION getFestivals()
RETURNS TABLE
AS
RETURN
(
 SELECT * FROM festivals
)

CREATE SYNONYM India.getFestivals  FOR dbo.getFestivals;
CREATE SYNONYM USA.getFestivals  FOR dbo.getFestivals;