2016. 3. 6. 01:35
| 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|type|text|0||0 1|name|text|0||0 2|tbl_name|text|0||0 3|rootpage|integer|0||0 4|sql|text|0||0 |
출처 : http://webkebi.zany.kr:9003/board/bView.asp?bCode=19&aCode=2538
'DB > sqlite' 카테고리의 다른 글
| [sqlite] DBI DBD on linux (0) | 2016.03.06 |
|---|---|
| [sqlite] rownum 기능 limit 기능으로 구한다. (0) | 2016.03.06 |
| [sqlite] perl select 쿼리 (0) | 2016.03.06 |
| [sqlite] perl 테이블 삭제/생성/인서트 (0) | 2016.03.06 |