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?
From stackoverflow
-
Try surrounding it in single quotes
DBCC CHECKIDENT ('Chemical.Products', RESEED, 0) -
You can surround with single quotes or inside square brackets. Both work.
DBCC CHECKIDENT ('Chemical.Products', RESEED, 0) DBCC CHECKIDENT ([Chemical.Products], RESEED, 0)
0 comments:
Post a Comment