Home › SQL Server › SQL Server CE

SQL Server CE - IDENTITY Columns


Reseed an existing IDENTITY column

ALTER TABLE Customer ALTER COLUMN CustomerID IDENTITY (100, 1)

Finding the next identity value of a table

SELECT 
	AUTOINC_NEXT 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE 
	TABLE_NAME = N'TableName' 
	AND COLUMN_NAME = N'ColumnName'

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.
  • 5667 reads