On Aug 9, 2005, at 8:11 AM, Olivier Salaün - CRU wrote:
Does SQLite provide an equivalent for the mysql "SHOW FIELDS" function that provides data type information about all fields in a table ?We need this feature to dynamically create/alter tables structure without requiring user interaction.
PRAGMA table_info(<tablename>)