Query Get Table's name
|
View:
New views
10 Messages
—
Rating Filter:
Alert me
|
 |
Query Get Table's name
by faiz aly
::
Rate this Message:
Dear Juggerr....
Apakah ada rekan2 yang tau SQL Query untuk get semua nama table dalam suatu database, saya sudah coba googling ko ga dapet ya?? please help.... Thanks Zabeedh Lebih Bersih, Lebih Baik, Lebih Cepat - Rasakan Yahoo! Mail baru yang Lebih Cepat hari ini! http://id.mail.yahoo.com |
|
|
Re: Query Get Table's name
by nova.saputra
::
Rate this Message:
sebelumnya: use [database_name];
trus: show tables; regards, nova.s faiz aly wrote: > > Dear Juggerr.... > > Apakah ada rekan2 yang tau SQL Query untuk get semua *nama table* > dalam suatu database, saya sudah coba googling ko ga dapet ya?? > please help.... > > Thanks > Zabeedh > > ------------------------------------------------------------------------ > Sikap Peduli Lingkungan? > <http://id.answers.yahoo.com/question/index;_ylt=AmebXXL7SVkXoWolLzM10BTJRAx.;_ylv=3?qid=20071018122153AAIUfb8> > > Temukan jawabannya di Yahoo! Answers! > |
|
|
Re: Query Get Table's name
by Muhammad Edwin
::
Rate this Message:
klo di *mysql *sih begini
SHOW TABLES FROM <nama database> 2009/10/27 faiz aly <nedvedh_05@...> > > > Dear Juggerr.... > > Apakah ada rekan2 yang tau SQL Query untuk get semua *nama table* dalam > suatu database, saya sudah coba googling ko ga dapet ya?? > please help.... > > Thanks > Zabeedh > > ------------------------------ > > |
|
|
Re: Query Get Table's name
by Aldian Fajri Hadi
::
Rate this Message:
Coba googling tentang "database metadata"
dan java.sql.DatabaseMetaData Aldian http://www.aldianfazrihady.com --- In jug-indonesia@..., faiz aly <nedvedh_05@...> wrote: > > Dear Juggerr.... > > Apakah ada rekan2 yang tau SQL Query untuk get semua nama table dalam suatu database, saya sudah coba googling ko ga dapet ya?? > please help.... > > Thanks > Zabeedh > |
|
|
Re: Query Get Table's name
by Eko Kurniawan Khannedy-2
::
Rate this Message:
kalo pake mysql tinggal query DESC TABLE_NAME aja
tar pas ResultSet nya tinggal getString(1) [maksudnya kolom ke-1] faiz aly wrote: > > Dear Juggerr.... > > Apakah ada rekan2 yang tau SQL Query untuk get semua *nama table* > dalam suatu database, saya sudah coba googling ko ga dapet ya?? > please help.... > > Thanks > Zabeedh -- contact me at : blog : http://eecchhoo.wordpress.com/ email : echo.khannedy[at]gmail.com ym : echo.khannedy phone : 085292775999 good luck! |
|
|
Re: Query Get Table's name
by Eko Kurniawan Khannedy-2
::
Rate this Message:
eh kirain cari nama kolom :D (bacanya keburu2)
yup kayak jawaban jugger yang lain bisa pake SHOW TABLES ato bisa pake Metadata :D --- In jug-indonesia@..., Eko Kurniawan Khannedy <echo.milisgroup@...> wrote: > > kalo pake mysql tinggal query DESC TABLE_NAME aja > tar pas ResultSet nya tinggal getString(1) [maksudnya kolom ke-1] > > > faiz aly wrote: > > > > Dear Juggerr.... > > > > Apakah ada rekan2 yang tau SQL Query untuk get semua *nama table* > > dalam suatu database, saya sudah coba googling ko ga dapet ya?? > > please help.... > > > > Thanks > > Zabeedh > > > -- > > contact me at : > > blog : http://eecchhoo.wordpress.com/ > email : echo.khannedy[at]gmail.com > ym : echo.khannedy > phone : 085292775999 > > good luck! > |
|
|
RE: Re: Query Get Table's name
by Adelwin, Adelwin
::
Rate this Message:
Kalo di oracle beda lagi...
Select * from all_tables Select * from all_tab_columns Select * from all_tab_constraints Beda2 semua pasti... Baik nya kalo mau generic yah pake MetaData... Khan ada ResultSetMetaData class... Dan kalo gak salah ada ConnectionMetaData juga.. Ini bisa buat ambil catalogs, table names, column names juga... Dulu pernah bikin iBatis query generator, perlu ginian neh... Tapi udah lama banget... Google It! Hehehe Jadi ntar tinggal metadata.getCatalogs(), metadata.getTables(), metadata.getColumns(tableName), Tapi ada susah nya juga... Metadata class ini nih beda2 untuk tiap DB Provider... Karna khan library nya khan masing2 punya... Jadi ntar ada OracleResultSetMetaData... yah code to an interface ajah kalo gituh... Soal nya khan common JDBC Interface Bisa deh Adelwin Handoyo | Senior Consultant - Wholesale Bank Standard Chartered Bank Plaza By The Park #06-00, 51 Bras Basah Road. Singapore (189554) T : (65) 655 72441 | E adelwin.adelwin@... ________________________________ From: jug-indonesia@... [mailto:jug-indonesia@...] On Behalf Of echo_khannedy Sent: Tuesday, October 27, 2009 1:15 PM To: jug-indonesia@... Subject: [JUG-Indonesia] Re: Query Get Table's name eh kirain cari nama kolom :D (bacanya keburu2) yup kayak jawaban jugger yang lain bisa pake SHOW TABLES ato bisa pake Metadata :D --- In jug-indonesia@... <mailto:jug-indonesia%40yahoogroups.com> , Eko Kurniawan Khannedy <echo.milisgroup@...> wrote: > > kalo pake mysql tinggal query DESC TABLE_NAME aja > tar pas ResultSet nya tinggal getString(1) [maksudnya kolom ke-1] > > > faiz aly wrote: > > > > Dear Juggerr.... > > > > Apakah ada rekan2 yang tau SQL Query untuk get semua *nama table* > > dalam suatu database, saya sudah coba googling ko ga dapet ya?? > > please help.... > > > > Thanks > > Zabeedh > > > -- > > contact me at : > > blog : http://eecchhoo.wordpress.com/ <http://eecchhoo.wordpress.com/> > email : echo.khannedy[at]gmail.com > ym : echo.khannedy > phone : 085292775999 > > good luck! > This email and any attachments are confidential and may also be privileged. If you are not the addressee, do not disclose, copy, circulate or in any other way use or rely on the information contained in this email or any attachments. If received in error, notify the sender immediately and delete this email and any attachments from your system. Emails cannot be guaranteed to be secure or error free as the message and any attachments could be intercepted, corrupted, lost, delayed, incomplete or amended. Standard Chartered PLC and its subsidiaries do not accept liability for damage caused by this email or any attachments and may monitor email traffic. Standard Chartered PLC is incorporated in England with limited liability under company number 966425 and has its registered office at 1 Aldermanbury Square, London, EC2V 7SB. Standard Chartered Bank ("SCB") is incorporated in England with limited liability by Royal Charter 1853, under reference ZC18. The Principal Office of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the United Kingdom, SCB is authorised and regulated by the Financial Services Authority under FSA register number 114276. If you are receiving this email from SCB outside the UK, please click http://www.standardchartered.com/global/email_disclaimer.html to refer to the information on other jurisdictions. |
|
|
Re: Query Get Table's name
by Niksen Harjanto
::
Rate this Message:
Kalo di Ms SQL Server bisa pake SELECT name FROM sysobjects;
2009/10/27 faiz aly <nedvedh_05@...> > > > Dear Juggerr.... > > Apakah ada rekan2 yang tau SQL Query untuk get semua *nama table* dalam > suatu database, saya sudah coba googling ko ga dapet ya?? > please help.... > > Thanks > Zabeedh > > ------------------------------ > Sikap Peduli Lingkungan? > <http://id.answers.yahoo.com/question/index;_ylt=AmebXXL7SVkXoWolLzM10BTJRAx.;_ylv=3?qid=20071018122153AAIUfb8> > Temukan jawabannya di Yahoo! Answers! > > |
|
|
Re: Re: Query Get Table's name
by Endy Muhardin
::
Rate this Message:
On Tue, Oct 27, 2009 at 12:43 PM, Adelwin, Adelwin
<Adelwin.Adelwin@...> wrote: > > Beda2 semua pasti… > > Baik nya kalo mau generic yah pake MetaData… > > Khan ada ResultSetMetaData class… > > Dan kalo gak salah ada ConnectionMetaData juga.. > > Ini bisa buat ambil catalogs, table names, column names juga… > > Dulu pernah bikin iBatis query generator, perlu ginian neh… > > Tapi udah lama banget… Ini juga gak reliable. Sangat tergantung kapabilitas JDBC drivernya. Kalo JDBC drivernya gak support, ya gak bisa. Intinya sih, sampe saat ini gak ada cara yang seragam tapi reliable untuk semua DB. -- Endy Muhardin http://endy.artivisi.com Y! : endymuhardin -- life learn contribute -- ------------------------------------ Kalau mau keluar dari mailing list ini, caranya kirim sebuah email ke jug-indonesia-unsubscribe@.... Jangan lupa, website JUG Indonesia adalah http://www.jug.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/jug-indonesia/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/jug-indonesia/join (Yahoo! ID required) <*> To change settings via email: mailto:jug-indonesia-digest@... mailto:jug-indonesia-fullfeatured@... <*> To unsubscribe from this group, send an email to: jug-indonesia-unsubscribe@... <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ |
|
|
RE: Re: Query Get Table's name
by Adelwin, Adelwin
::
Rate this Message:
Sorry... gue koreksi pernyataan gue sendiri
Hahaha ResultSetMetadata ituh interface :p Hahaha Dan so far, database yang gue pake sih sediain implementation class nya di driver nya HsqlDB, Derby, Oracle, MSSqlServer, MySQL Apa lagi? Itu yang mainstream khan yah? Adelwin Handoyo | Senior Consultant - Wholesale Bank Standard Chartered Bank Plaza By The Park #06-00, 51 Bras Basah Road. Singapore (189554) T : (65) 655 72441 | E adelwin.adelwin@... -----Original Message----- From: jug-indonesia@... [mailto:jug-indonesia@...] On Behalf Of Endy Muhardin Sent: Wednesday, October 28, 2009 3:15 PM To: jug-indonesia@... Subject: Re: [JUG-Indonesia] Re: Query Get Table's name On Tue, Oct 27, 2009 at 12:43 PM, Adelwin, Adelwin <Adelwin.Adelwin@...> wrote: > > Beda2 semua pasti... > > Baik nya kalo mau generic yah pake MetaData... > > Khan ada ResultSetMetaData class... > > Dan kalo gak salah ada ConnectionMetaData juga.. > > Ini bisa buat ambil catalogs, table names, column names juga... > > Dulu pernah bikin iBatis query generator, perlu ginian neh... > > Tapi udah lama banget... Ini juga gak reliable. Sangat tergantung kapabilitas JDBC drivernya. Kalo JDBC drivernya gak support, ya gak bisa. Intinya sih, sampe saat ini gak ada cara yang seragam tapi reliable untuk semua DB. -- Endy Muhardin http://endy.artivisi.com Y! : endymuhardin -- life learn contribute -- ------------------------------------ Kalau mau keluar dari mailing list ini, caranya kirim sebuah email ke jug-indonesia-unsubscribe@.... Jangan lupa, website JUG Indonesia adalah http://www.jug.or.id Yahoo! Groups Links This email and any attachments are confidential and may also be privileged. If you are not the addressee, do not disclose, copy, circulate or in any other way use or rely on the information contained in this email or any attachments. If received in error, notify the sender immediately and delete this email and any attachments from your system. Emails cannot be guaranteed to be secure or error free as the message and any attachments could be intercepted, corrupted, lost, delayed, incomplete or amended. Standard Chartered PLC and its subsidiaries do not accept liability for damage caused by this email or any attachments and may monitor email traffic. Standard Chartered PLC is incorporated in England with limited liability under company number 966425 and has its registered office at 1 Aldermanbury Square, London, EC2V 7SB. Standard Chartered Bank ("SCB") is incorporated in England with limited liability by Royal Charter 1853, under reference ZC18. The Principal Office of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the United Kingdom, SCB is authorised and regulated by the Financial Services Authority under FSA register number 114276. If you are receiving this email from SCB outside the UK, please click http://www.standardchartered.com/global/email_disclaimer.html to refer to the information on other jurisdictions. |
| Free embeddable forum powered by Nabble | Forum Help |
