Menu
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?
260
DBCC CHECKIDENT returns the current identity value and the current maximum value of the identity column. If the two values are not the same, you should reset the identity value to avoid potential errors or gaps in the sequence of values.
You can surround with single quotes or inside square brackets. Both work.
DBCC CHECKIDENT ('Chemical.Products', RESEED, 0) DBCC CHECKIDENT ([Chemical.Products], RESEED, 0) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
