I want to fetch the definition of views from a .mdb file. Can yoi please tell me if I can do this by using your driver. If yes, also tell me how can i do it?
|
A standard sql syntax, which is differ from MS Access, can be seen through REMARKS column in DatabaseMetaData.getTables.
|
can you please tell me the exact syntax. I tried the sql syntax but was unable to fetch the definition of views.
|
>I tried the sql syntax but was unable to fetch the definition of views.
That sql is the definition of one view. For instance,
ResultSet viewRs=dbmd.getTables(null,null,"%",new String[]{"VIEW"});
if(viewRs.next()){
String yourWantSql=viewRs.getString("REMARKS");
//...
}
|