How do I know the designated column’s table name?
String query = "SELECT a.id, a.quantity, a.price, c.name "
+ "FROM order_details a "
+ "LEFT JOIN orders b ON a.order_id = b.id "
How do I know if a table column can have a null value or not?
How do I get column’s precision and scale value?