MySQL Forums :: Workbench - Plugins & Utilities :: Reading column types from views?
Reading column types from views?
Posted by: Karsten Wutzke ()
Date: February 16, 2011 08:56PM
Hello,
is there a way to determine the column types of a view easily? All I found is the list of column names as strings, but that doesn't suffice. I really need to read the types that result from the SELECT statement that created the view.
Is there a way? How do you get access to the SQL SELECT statement to reconstruct the type info? (Python)
Karsten
is there a way to determine the column types of a view easily? All I found is the list of column names as strings, but that doesn't suffice. I really need to read the types that result from the SELECT statement that created the view.
Is there a way? How do you get access to the SQL SELECT statement to reconstruct the type info? (Python)
Karsten
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Reading column types from views? | 3033 | Karsten Wutzke | 02/16/2011 08:56PM |
| Re: Reading column types from views? | 1228 | Alfredo Kengi Kojima | 02/18/2011 06:26AM |
| Re: Reading column types from views? | 966 | Karsten Wutzke | 02/18/2011 07:52AM |
| Re: Reading column types from views? | 935 | Karsten Wutzke | 02/18/2011 08:40AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates