CODEWITHSUNDEEP
sqlitesystem-tables
Jonathan Freitas
Jonathan Freitas

Reputation: 61

What's the difference between name and tbl_name in sqlite_master?

What's the difference between name and tbl_name in sqlite_master?

Upvotes: 6

Views: 2372

Answers (1)

CL.
CL.

Reputation: 180080

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.

Upvotes: 5

Related Questions