SQL Server : CREATE SEQUENCE - unknown object type

Question

I encounter a problem with the following part of a query:

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

It keeps telling me, that sys.sequences is an unknown object name and seq.schema_id cannot be resolved.

I run SQL Server Express 2008 R2.

How do I Fix this?

How to fix it? Upgrade to SQL Server 2012 - sequences are a new feature in the 2012 release — marc_s
– marc_s, Commented Oct 9, 2012 at 12:18

Joe G Joseph · Accepted Answer · 2012-10-09 12:00:05Z

7

sys.sequences table is not available in sql server 2008

Sequence is introduced in sql server from SQL server 2012

Click here

answered Oct 9, 2012 at 12:00

Joe G Joseph

24.2k5 gold badges58 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

billdoor Over a year ago

found out seconds later and forgot to close this, thank you anyway^^

Collectives™ on Stack Overflow

SQL Server : CREATE SEQUENCE - unknown object type

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related