ivo welch wrote: > * SHOW columns FROM table --- would be a great addition, if only > for compatibility with MySQL. Aside, it is easier to remember than a > pragma.
MySQL's SHOW features are just an old MySQL-proprietary way of doing introspection, prior to their adding support for the SQL standard INFORMATION_SCHEMA. If SQLite is going to add any introspection features for compatability with other DBMSs, it should go the information schema route, or in SQLite terms, information database. -- Darren Duncan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users