Home Forums SQL Server 7,2000 T-SQL Creating Views: Changing column names RE: Creating Views: Changing column names

  • I have another one that I'm trying to solve:

     

       Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created.

     

    Can any one help me on this one