create schema marketing;
GO
create schema HR;
GO
ALter schema marketing TRANSFER dbo.customers;
GO
ALTER schema marketing TRANSFER dbo.orders;
GO
ALTER schema HR TRANSFER dbo.employees;
GO
CREATE SYNONYM customers FOR marketing.customers;
CREATE SYNONYM SOrders FOR marketing.orders;
CREATE SYNONYM SEmployees FOR HR.employees;
SELECT * FROM SEmployees;
GO
sp_help customers;