reset password
Author Message
jpascua
Posts: 197
Posted 12:09 Nov 09, 2015 |

Is there a way to view all existing tables in the DB?

cysun
Posts: 2935
Posted 15:33 Nov 09, 2015 |

Run a query on the system catalog tables. For example, "select tblname from tblcat".
 

mchaouq
Posts: 1
Posted 17:52 Nov 09, 2015 |

I don't understand how/why do we need to use the projectScan.java in the 1st question.

Can anyone please explain this ?

Thank you

raywu64
Posts: 44
Posted 15:50 Nov 11, 2015 |
cysun wrote:

Run a query on the system catalog tables. For example, "select tblname from tblcat".
 

Is there a similar query for selecting column names from the table? I've been stuck on this part of the HW assignment. 

If there isn't a way to find the column names using a query, I also tried looking for a way to access the Schema but no luck with that. 

My third thought was to keep track of the list of columns and pass it in every step until it gets to Parser, but that doesn't sound like the correct solution. 

cysun
Posts: 2935
Posted 16:09 Nov 11, 2015 |

Read the existing code and see where it gets the column names.

vsluong4
Posts: 87
Posted 16:19 Nov 11, 2015 |

Get the table metadata from a Table manager, from that extract the schema, and that should have the field names