text: ---------------------------------------------------------------------
  -- LAB 16
  --
  -- Exercise 4
  ---------------------------------------------------------------------
  
  USE TSQL;
  GO
  
  ---------------------------------------------------------------------
  -- Task 1
  -- 
  -- Write T-SQL code to create a synonym named dbo.Person for the Person.Person table in the AdventureWorks database. Execute the written statement.
  --
  -- Write a SELECT statement against the dbo.Person synonym and retrieve the FirstName and LastName columns. Execute the SELECT statement.
  --
  -- Observe and compare the results that you got with the recommended result shown in the file 82 - Lab Exercise 4 - Task 1 Result.txt.
  ---------------------------------------------------------------------
  
  
  
  ---------------------------------------------------------------------
  -- Task 2
  -- 
  -- Execute the provided T-SQL code to remove the synonym.
  ---------------------------------------------------------------------
  
  DROP SYNONYM dbo.Person;