pake TOAD aja desc NAMA_TABLE -> klik tab Script
CMIIW 2006/12/21, Oscar Wilyanto <[EMAIL PROTECTED]>: > > Thanks atas masukannya, > > Saya sudah buka tabel all_tab_columns, tapi berbeda sekali dengan 'show > create table'-nya MySQL (tabel ini mirip syntax DESCRIBE), padahal saya > membutuhkan informasi constraint/ foreign key dari table tersebut, lalu > ingin langsung membuat tabel baru dengan sedikit mengkopi dan memodifikasi > saja pada tanpa perlu mengetik ulang semua syntax create table-nya... > seperti contoh di MySQL ini: > > show create table item_rs; > > hasilnya: > > CREATE TABLE `item_rs` ( > `item_id` bigint(11) unsigned zerofill NOT NULL default '00000000000', > `rs_id` int(6) unsigned zerofill NOT NULL default '000000', > `no_po` int(6) default NULL, > `no_pr` int(6) default NULL, > `item_nama` varchar(100) default NULL, > `no_batch` bigint(11) default NULL, > `kemasan` varchar(20) default NULL, > `satuan` varchar(10) default NULL, > `no_fpa` int(6) default NULL, > `quantity` int(10) default NULL, > PRIMARY KEY (`item_id`,`rs_id`), > KEY `rs_id` (`rs_id`), > CONSTRAINT `item_rs_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `item` > (`id`) ON DELETE CASCADE ON UPDATE CASCADE, > CONSTRAINT `item_rs_ibfk_2` FOREIGN KEY (`rs_id`) REFERENCES `rs` (`id`) > ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > > Please Help.. > > Thanks, > Oscar > > ----- Original Message ----- > From: Firman H.M. > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Thursday, December 21, 2006 2:27 PM > Subject: Re: [indo-oracle] Show create table di Oracle > > Coba buka tabel all_tab_columns. > Semua table beserta kolom dan type datanya ada disana. > > Semoga membantu > > CMIIW > > 2006/12/21, Oscar Wilyanto <[EMAIL PROTECTED] <oscar%40mkdgroup.com>>: > > > > Dear Masters, > > > > Apakah Oracle punya perintah untuk menampilkan SQL syntax pembuatan > tabel > > yang sudah eksis? (di MySQL menggunakan 'show create table nama_tabel') > > > > Thanks in Advance, > > Oscar > > > > ---------------------------------------------------------- > > This message contains confidential information and is intended only for > > the > > individual named. If you are not the named addressee you should not > > disseminate, distribute or copy this e-mail. Please notify the sender > > immediately by e-mail if you have received this e-mail by mistake and > > delete > > this e-mail from your system. E-mail transmission cannot be guaranteed > to > > be > > secure or error-free as information could be intercepted, corrupted, > lost, > > destroyed, arrive late or incomplete, or contain viruses. MKD Group > > therefore > > does not accept liability for any errors or omissions in the contents of > > this > > message, which arise as a result of e-mail transmission. If verification > > is > > required please request a hard-copy version. > > > > MKD Group, www.mkdgroup.com > > ---------------------------------------------------------- > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > ---------------------------------------------------------- > This message contains confidential information and is intended only for > the > individual named. If you are not the named addressee you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately by e-mail if you have received this e-mail by mistake and > delete > this e-mail from your system. E-mail transmission cannot be guaranteed to > be > secure or error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. MKD Group > therefore > does not accept liability for any errors or omissions in the contents of > this > message, which arise as a result of e-mail transmission. If verification > is > required please request a hard-copy version. > > MKD Group, www.mkdgroup.com > ---------------------------------------------------------- > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
