hi all, i'd like to get columns remarks from a table and insert those as a row into the table. Is that possible?
So, if I had a MYTABLE of columns "A" and "B", and I have remarks for those columns in the schema, I would like to put the remarks as follows INSERT INTO MYTABLE VALUES(<remarks for A>, <remarks for B>); I know I can get the remarks directly from schema: SELECT COLUMN_NAME, REMARKS FROM INFORMATION_SCHEMA.COLUMNS WHERE REMARKS <> '' AND TABLE_NAME = 'MYTABLE'; But, it looks, this will not help me to insert the remarks. Any ideas? Thank you! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f5a0ff71-2087-4cd2-b543-ee1e8b9aa579o%40googlegroups.com.
