Using SQL Lite to code, provide code solutions * 6. The database designers have

Question

Using SQL Lite to code, provide code solutions

* 6. The database designers have agreed that creating new assignment ID numbers is a burden. Therefore, they want to make the EQUIP_ASSIGN_ID column in the EQUIP_ASSIGN LOG table increment automatically with each new row that is inserted into the table. Once a table has been created it is very tricky to add an autoincrement feature. It can be done in most DB management systems, but SQLite is not one of them. We will need to delete the table and build it again with the autoincrement feature in the primary key. Write a statement that deletes the EQUIP_ASSIGN_LOG table from the database.

Explanation / Answer

Statement :

DROP TABLE EQUIP_ASSIGN_LOG;

Explanation :

At first, auto-increment feature not present in table schema and we neet to alter the schema.

If DELETE TABLE EQUIP_ASSIGN_LOG; used schema will not be deleted.Only records are deleted.

Using DROP, Once the table is dropped then table with new schema can be created.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.