Can i delete information schema

Viewed times. Improve this question. Why do you want to delete them? You can't drop it in SQL Server anyway. There's no implementation to do anything apart from read from them. Due to the age of the implementation these are protected against and aren't likely.

So, don't worry about it, worry about the users writing SQL injection vulnerable code. Which version of which product?? Add a comment. Active Oldest Votes. Sign up or log in Sign up using Google. Standards Considerations. Related Information. They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on them. Also, there is no database directory with that name. Explanation: The statement requests a list of all the tables in database db5 , showing just three pieces of information: the name of the table, its type, and its storage engine.

For more information, see Section This technique is more interoperable with other database systems. Connect and share knowledge within a single location that is structured and easy to search. Once I logged in I noticed databases already created and within them tons of tables and rows.

My question of course is whether I can just delete them all without failing the system in any way. Below you see what I saw once I entered the first database. Please refer to the MySQL documentation on this.

One excerpt:. They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on them. Also, there is no database directory with that name. So, no, don't attempt to delete them. You need them in order to have a functional MySQL installation. Ubuntu Community Ask! Sign up to join this community.

The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?