Answers for "reset primary key sql server"

SQL
1

primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)
Posted by: Guest on October-11-2020
1

change primary key sql

ALTER TABLE <Table_Name>
DROP CONSTRAINT <constraint_name>

ALTER TABLE <Table_Name>
ADD CONSTRAINT <constraint_name> PRIMARY KEY (<Column1>,<Column2>)
Posted by: Guest on September-21-2020
0

reseed sql table primary key

DBCC CHECKIDENT ('YourTableName', RESEED, 1)
Posted by: Guest on December-04-2020

Code answers related to "reset primary key sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language