Let’s assume that you have an existing relational database.
What options do you have for removing a table from the database?
Is it possible to modify a table, i.e., adding or removing a column or changing a column’s type?
Can you remove any table at any time?
What happens to foreign key references when a table is dropped?
Are there restrictions on dropping tables?
Can you modify any table in any way or are there limits?
Do some research on this focusing on SQLite as the database. What are the SQL statements for such activities? Provide examples.
