Home Forums SQL Server 7,2000 T-SQL Create a View with OPTION (FORCE ORDER) RE: Create a View with OPTION (FORCE ORDER)

  • August 2, 2005 at 5:10 pm

    #578996

    -- this works

    SELECT c.Name + '.' + o.Name AS Foo

    FROM SysColumns c

    INNER JOIN SysObjects o ON c.id=o.id

    OPTION (FORCE ORDER)

    GO

    -- This works

    CREATE VIEW Test1 AS

      SELECT c.Name + '.' + o.Name AS Foo

      FROM SysColumns c

      INNER JOIN SysObjects o ON c.id=o.id

    GO

    -- This fails

    CREATE VIEW Test2 AS

      SELECT c.Name + '.' + o.Name AS Foo

      FROM SysColumns c

      INNER JOIN SysObjects o ON c.id=o.id

      OPTION (FORCE ORDER)

    GO