Hello! It's very important to have place to store table metainformation. In all common DBMSs we can use TABLE/COLUMN COMMENT as meta description of table but SQLite doesn't support it.
COMMENTs are supported from very old to new PostgreSQL: http://www.postgresql.org/docs/7.1/static/sql-comment.html http://www.postgresql.org/docs/9.2/static/sql-comment.html MySQL: http://dev.mysql.com/doc/refman/5.1/en/create-table.html ORACLE: http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_4009.htm IBM DB2: http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_addandretrievecommentsfromcatalog.htm Sybase: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1510/html/iqrefso/X315695.htm P.S. Field type is bad storage for additional information because there are a lot of conversion problems from some bindings (including official tclsqlite) when column types are non-standard. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
