What's the difference between name and tbl_name in sqlite_master?
Asked
Active
Viewed 1,965 times
6
CL.
- 173,858
- 17
- 217
- 259
Jonathan Freitas
- 61
- 3
-
[The SQLite Database File Format](https://www.sqlite.org/fileformat2.html) Search for `tbl_name`, This will lead to an explanation as follow:: _The sqlite_master.tbl_name column holds the name of a table or view that the object is associated with. For a table or view, the tbl_name column is a copy of the name column. For an index, the tbl_name is the name of the table that is indexed. For a trigger, the tbl_name column stores the name of the table or view that causes the trigger to fire._ – Ryan Vincent Sep 05 '15 at 18:57
1 Answers
5
As shown in the documentation, there is no difference if the entry describes a table.
For indexes and triggers, name is the name of the object itself, while tbl_name is the name of the table that the object belongs to.
CL.
- 173,858
- 17
- 217
- 259