String[] supportedTableTypes =  new  String[ 2 ];
 int  l= 0 ;
supportedTableTypes[l++] = "TABLE";
supportedTableTypes[l++] = "VIEW";
 try  
{			
       Class .forName("sun.jdbc.odbc.JdbcOdbcDriver");			
      Connection con = DriverManager.getConnection("jdbc:odbc:test");
      DatabaseMetaData meta = con.getMetaData();			
      ResultSet rs = meta.getTables( null ,  null , "%", supportedTableTypes);	
       while  (rs.next())
      {				
          String tCatalog = rs.getString( 1 );       // TABLE_CAT
          String tSchema = rs.getString( 2 );        // TABLE_SCHEM
          String tName = rs.getString( 3 );          // TABLE_NAME
          String tType = rs.getString( 4 );          // TABLE_TYPE
          String tDescription = rs.getString( 5 );   // REMARKS      
     }
} 
 catch  (Exception e) {...}