select sql from sqlite_master where tbl_name='my_table_name' and type='index' you can find the index name and column names in ‘sql’ field. See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names ... Read more
Tag Archives: Sqlite
How to get primary key of a table from SQLite
Run PRAGMA table_info('my_table_name') find the record that column ‘pk’ is 1, it’s the primary key. See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from MySQL How to get primary key of a table from SQL Server How to get primary key ... Read more
How to generate a CREATE TABLE statement for a given table in SQLite
select sql from sqlite_master where type='table' and tbl_name='country' See also: How to generate a CREATE TABLE statement for a given table in SQL Server How to generate a CREATE TABLE statement for a given table in Oracle How to generate a CREATE TABLE statement for a given table in ... Read more
How to get column names from SQLite table
PRAGMA table_info(table_name); see also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Oracle table How to get column names from Mysql table How to get column names from PostgreSQL table Some SQLite tools you can try: ... Read more
Withdata Software Released SqliteLobEditor Version 1.1
Withdata software has announced sqlitelobeditor 1.1, a tool that helps you edit SQLite lob (blob, clob (text, ntext)) data directly. Version 1.1 Add “Create sub folders by field name”. Add “turning off log” in command line. Fix bug “logon to SQLite form UI ... Read more
Withdata Software Released SqliteToExcel Version 1.1
Withdata software has announced sqlitetoexcel 1.1, a data conversion tool that export SQLite data to excel. Version 1.1 Add “turning off log” in command line. Withdata SqliteToExcel – Tool for exporting Sqlite data to Excel Withdata SqliteToExcel is convenient: 1. Easy visually ... Read more
Withdata Software Released SqliteToTxt Version 1.1
Withdata software has announced sqlitetotxt 1.1, a data conversion tool that export SQLite data to flat file (csv, tsv, xml, html, sql) and excel. Version 1.1 Add “turning off log” in command line. Add an option for “replace CRLF with space”. SqliteToTxt – The better ... Read more
Withdata Software Released XlsToSqlite Version 1.1
Withdata software has announced xlstosqlite 1.1, a data conversion tool that import Excel data to SQLite database. Version 1.1 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command ... Read more
Withdata Software Released TxtToSqlite Version 1.1
Withdata software has announced txttosqlite 1.1, a data conversion tool that import txt (csv, tsv) data to SQLite database. Version 1.1 Add “Bad File” to log failed import records. Add “Exception Report From”. Improve import performance. TxtToSqlite – Better tool to ... Read more
Withdata Software Released SqliteToPostgres Version 1.0
Withdata software has announced sqlitetopostgres 1.0, a data conversion tool that convert SQLite data to PostgreSQL database. Version 1.0 is the first release. SqliteToPostgres – Convert SQLite data to PostgreSQL SqliteToPostgres is convenient: 1. Easy visually config, just click on the ... Read more