IF object_id(N'dbo.myView', 'V') IS NOT NULL
        DROP VIEW dbo.myView
      GO

      CREATE VIEW dbo.myView AS
          SELECT    TOP 10 * 
          FROM      myTable 
          ORDER BY  ID      DESC