i have two questions 1)How can i use the previously deleted id value to new record.In sqlite we don't have identity column so i used auto increment keyword can i use set identity_insert here 2)Is there any possibility of using DBCC to reset id values
CREATE TABLE "Customer"(
"Id" integer primary key autoincrement not null ,
"Name" varchar ,
"Mid" varchar ,
"Year" integer ,
"Semester" integer )
Aucun commentaire:
Enregistrer un commentaire