table names used in the epay application

Posted by Sudheep.Grandhe under Others on 11/14/2013 | Points: 10 | Views : 1571 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts