Getting all the columns in Android

Question

Hi, Can anyone please tell me how can I get all the column names used in a database table in Android..?

Answer 1

Two possible ways i can think of:

PRAGMA table_info(yourTable)

or

SELECT * FROM yourTable LIMIT 0

To get all tables:

SELECT * FROM sqlite_master WHERE type = 'table'

Answer 2

• c.getColumnName(0)

access cursor property 0,1,2 pass as many column u have