sqlite> pragma table_info(CITY_INFO); 0|CITY_ID|INTEGER|1||0 1|CITY_NAME|TEXT|1||0 2|UPDATE_DATE|TIMESTAMP|0|CURRENT_TIMESTAMP|0 또는 sqlite> select * from sqlite_master where tbl_name='CITY_INFO'; table|CITY_INFO|CITY_INFO|13|CREATE TABLE CITY_INFO ( CITY_ID INTEGER NOT NULL, CITY_NAME TEXT NOT NULL , UPDATE_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) sqlite> pragma table_info(sqlite_master); 0|ty..

SQLite의 커맨드라인 명령어는 .tables sqlite> .tables query로 하려면 아래처럼. // 간단버전 (테이블에 대한 모든 걸 몽땅 가져옴) SELECT * FROM sqlite_master WHERE type='table'; // 제대로 된 버전 (테이블 이름만 가져옴) SELECT name FROM sqlite_master WHERE type IN ('table', 'view') AND name NOT LIKE 'sqlite_%' UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table', 'view') ORDER BY 1; 참고: http://www.sqlite.org/sqlite.html