Using RDBMS, we store data and metadata in logical tables (which are stored in operating system files). Typically, each database vendor has different types of logical storage types (such as TABLE, VIEW, SYSTEM TABLE, etc.) for storing data and metadata. For example, Oracle does support most of the table types, but some databases (such as MySQL) do not support “views” (MySQL 5.0 does support views, however). In GUI database applications, you might want to distinguish different table types. The getTableTypes() method, defined in the DatabaseMetaData interface, retrieves the table types available in this database. The results are ordered by table type. The result is returned as a ResultSet object in which each row has a single String column that is a table type. A single column is named as TABLE_TYPE.
The table type is
The Solution: getTableTypes()
Oracle Client Program//// print the list of table types//
MySQL Client Program//// print the list of table types//
MySQL Client Program Output
JDBC Related Interview Questions
|Core Java Interview Questions||JSP Interview Questions|
|Java Servlets Interview Questions||EJB(Enterprise JavaBeans) Interview Questions|
|JSTL(JSP Standard Tag Library) Interview Questions||JNDI (Java Naming and Directory Interface) Interview Questions|
|Java Bean Utils Interview Questions||AWT (Abstract Window Toolkit) Interview Questions|
What Is Jdbc Programming?
Database Metadata, Part 1
Database Metadata, Part 2
Exploring Driver Property Information
Rowset Metadata A
Web Access To Metadata,part 1
Web Access To Metadata, Part 2
Rdf And Jdbc Metadata
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.