DBCC CHECKIDENT -- Schema aware???

Question

I've got a different schema (besides dbo) that I've created a table in, schema "Chemical".

I've tried 4 different variations of this DBCC CHECKIDENT, and they all bring back the same error:

"Incorrect syntax near '.'"

I've tried:

DBCC CHECKIDENT (Chemical.[Products], RESEED, 0)

DBCC CHECKIDENT (Chemical.Products)

DBCC CHECKIDENT ([Chemical].[Products])

DBCC CHECKIDENT (Chemical.Products, RESEED, 0)

Is it schema aware or what am I missing?

Answer 1

Try surrounding it in single quotes

DBCC CHECKIDENT ('Chemical.Products', RESEED, 0)

Answer 2

You can surround with single quotes or inside square brackets. Both work.

DBCC CHECKIDENT ('Chemical.Products', RESEED, 0)
DBCC CHECKIDENT ([Chemical.Products], RESEED, 0)