table names used in the epay application

Posted by Sudheep.Grandhe under Others on 11/14/2013 | Points: 10 | Views : 1799 | Status : [Member] | Replies : 1
Find all the table names used in the epay application. Search application "tbl_" and Create a Java file, in which write the following query to get the table structure of each tables.

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

Best,
Sudheep.



Responses

Posted by: Bandi on: 11/14/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer these links once
http://stackoverflow.com/questions/5572793/sql-parser-library-for-java-retrieve-the-list-of-table-names-present-in-a-sql
http://www.dpriver.com/blog/list-of-demos-illustrate-how-to-use-general-sql-parser/get-columns-and-tables-in-sql-script/

http://www.roseindia.net/jdbc/jdbc-mysql/AllTableName.shtml //Here search for table name startsWith "tbl_"

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response