Re: [sqlite] Equivalent for "SHOW FIELDS"

[Will Leshner]

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()

[sqlite] Equivalent for "SHOW FIELDS"

[Olivier Salaün - CRU]

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.




smime.p7s
Description: S/MIME Cryptographic Signature