mysqlshow equivalent?

Dev Shed Forums Sponsor:

March 15th, 2005, 09:11 AM

AxsDeny

Registered User

Join Date: Aug 2002

Location: Pittsburgh

Posts: 4

Time spent in forums: 17 m 14 sec
Reputation Power: 0

mysqlshow equivalent?

Please don't flame me too hard, I'm new to Oracle, so excuse my ignorance.

How do I get Oracle (9i) to show me the structure of a specific table along the same lines that the following mysql statement would:

mysqlshow DBname tablename;

If you need any more info, please let me know. Thanks for the help!

March 15th, 2005, 09:49 AM

djjhouse

Contributing User

Join Date: Oct 2004

Location: Colorado, USA

Posts: 68

Time spent in forums: 1 Day 15 h 7 m
Reputation Power: 4

you could try

Code:

select * from user_tables;

and/or

select * from cols;

These returns tons of information.

March 15th, 2005, 09:54 AM

AxsDeny

Registered User

Join Date: Aug 2002

Location: Pittsburgh

Posts: 4

Time spent in forums: 17 m 14 sec
Reputation Power: 0

Quote:

Originally Posted by djjhouse

you could try

Code:

select * from user_tables;

This returns tons of information.

I need it to return something like:

Code:

CREATE TABLENAME {
  blah varchar2(50),
  blah2 varchar(25)
}

March 15th, 2005, 10:02 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,923

Time spent in forums: 2 Months 3 Weeks 3 Days 18 h 38 m 51 sec
Reputation Power: 279

Google knows the answer

Note that a more appropriate subject would have been something like: "How to retrieve DDL (data definition language) for table?"

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

Last edited by pabloj : March 15th, 2005 at 10:09 AM.

March 15th, 2005, 12:08 PM

AxsDeny

Registered User

Join Date: Aug 2002

Location: Pittsburgh

Posts: 4

Time spent in forums: 17 m 14 sec
Reputation Power: 0

Quote:

Originally Posted by pabloj

Google knows the answer

Note that a more appropriate subject would have been something like: "How to retrieve DDL (data definition language) for table?"

Therein lied the problem. The syntax is pretty different from MySQL to Oracle, so I didn't even know what to search for. Trust me, forums are my last resort. Regardless, thanks for the help.

March 16th, 2005, 03:04 AM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,923

Time spent in forums: 2 Months 3 Weeks 3 Days 18 h 38 m 51 sec
Reputation Power: 279

The problem should be solved in MySQL 5, it will implement proper system views (like Oracle and other databases).

March 16th, 2005, 11:28 AM

paulh1983

Contributing User

Join Date: Dec 2004

Posts: 1,255

Time spent in forums: 1 Week 1 Day 15 h 14 m
Reputation Power: 17

simple answer is:

describe "your table name"; (without quotes eg if u have table called: student do: describe student;

simple

March 16th, 2005, 12:02 PM

AxsDeny

Registered User

Join Date: Aug 2002

Location: Pittsburgh

Posts: 4

Time spent in forums: 17 m 14 sec
Reputation Power: 0

Quote:

Originally Posted by paulh1983

simple answer is:

describe "your table name"; (without quotes eg if u have table called: student do: describe student;

simple

That doesn't do what I want. I want it to spit out the table creation code. Not to describe the columns within a table.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: