How to get table list of sqlite in iphone

stackoverflow.com 참조:

How to get list of all the tables in sqlite database in my application

up vote0down votefavorite share [g+]share [fb]share [tw]

I am creating a Sqlite database using terminal and integrating this database in my application. I need to get list of all the tables in the database. I know that in the terminal .tables displays list of all the tables in database but how do I do the same thing programatically. Could someone point me in the right direction? (Let me know if my question isn't entirely clear) iphone sqlite3 link|edit edited Mar 17 '11 at 4:51 Yi Jiang 16.3k22341 asked Mar 17 '11 at 4:32 MaheshBabu 739128 99% accept rate

@MaheshBabu: Jhaliya's answer is correct according to me. So please try that out. – Parth Bhatt Mar 17 '11 at 5:25 feedback

2 Answers

activeoldestvotes

up vote1down voteaccepted	try this : SELECT * FROM sqlite_master where type='table' link|edit answered Mar 17 '11 at 5:08 Mitesh Khatri 969217
	feedback

up vote2down vote	Use the below sql statement to get list of all table in sqllite data base SELECT * FROM dbname.sqlite_master WHERE type='table'; The same question asked before on StackOverFlow. How do I list the tables in a SQLite database file link|edit answered Mar 17 '11 at 4:52 Jhaliya 13.9k1613
	+1 for your answer because you have even provided the link in case it is not clear. :-) – Parth Bhatt Mar 17 '11 at 5:26 feedback