cogito ergo sum
sqllite3でテーブル名の取得
$sqllite3 sqlite> SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name; <テーブル名> sqlite>
$sqllite3 sqlite> SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name; <テーブル名> sqlite>
コメントを残す