For a book that I am writing on MaxDB I want to create a few self-made views on the system tables. But certain things I do not understand or I can not find them;
1) Where in the system tables does MaxDB store the fact that a view was created with the with-check-option? I can only find it in the view definition. 2) Ii is not possible to perform a LIKE operator on a LONG column. Is it possible to first transform that column into a smaller string and then apply the LIKE? 3) Where do I find the column privileges for all the users? For the table privileges that is easy? But it feels as if I am missing a system table. 4) If I would like to create a timestamp value out of the createdate and the createtime used in the domain.tables table. How do I do that efficiently? Hopefully, some one can help me with these questions. Thanks, Rick van der Lans
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
