title: SQL Server : CREATE SEQUENCE - unknown object type
body: <p>I encounter a problem with the following part of a query:</p>
  
  <pre><code>IF EXISTS (SELECT * FROM sys.sequences seq JOIN sys.schemas sch ON seq.schema_id=sch.schema_id WHERE seq.name=N'LID'  AND sch.name=N'dbo' )
     DROP SEQUENCE [dbo].[LID]
  GO
  </code></pre>
  
  <p>It keeps telling me, that <code>sys.sequences</code> is an unknown object name and <code>seq.schema_id</code> cannot be resolved.</p>
  
  <p>I run SQL Server Express 2008 R2.</p>
  
  <p>How do I Fix this?</p>