473,480 Members | 1,901 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Generating CREATE TABLE statements

Hi,

Is there any SQL command in Oracle that returns a "CREATE TABLE"
statement in Oracle. For example in MySQL there is a command called

"SHOW CREATE TABLE <tableName>"

This command can be sent from any client and it returns the script for
the table.

Thanks
Jan 30 '06 #1
1 8951

"Jack Miller" <jm@asdfaf.com> wrote in message
news:swrDf.2327$0J3.1435@trndny08...
Hi,

Is there any SQL command in Oracle that returns a "CREATE TABLE"
statement in Oracle. For example in MySQL there is a command called

"SHOW CREATE TABLE <tableName>"

This command can be sent from any client and it returns the script for
the table.

Thanks

look at the docs under pl/sql packages dbms_metadata.
Jim
Jan 31 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3004
by: Justin Lebar | last post by:
Sorry about the huge post, but I think this is the amount of information necessary for someone to help me with a good answer. I'm writing a statistical analysis program in ASP.net and MSSQL7 that...
1
2132
by: teohster | last post by:
Hi all, What I am trying to do is generate a stored procedure that is desired to output XML in this type of format <Parent Device> <Device> <Device ID>1</DeviceID> <ChildRegister>...
12
2462
by: Martin_Hurst | last post by:
Has some one come up with a similar type script that could be used in a Postgresql database? The script below was created for a SQLServer database. Thx, -Martin ...
2
2612
by: tom horner | last post by:
Any ideas on why drop and create alias statements would take a long time? We recently went through an upgrade of our production database, which included alter statements to table structures,...
0
867
by: Gary Miller | last post by:
I am using a Oracle 817. I generated an intial DataAdapter and DataSet. All statements geneated; Select, Update, Inssert and Delete. I add a new column to the Table, null allowed, varchar2. ...
9
5228
by: Jack Miller | last post by:
Hi, Is there any SQL that would return the "CREATE TABLE" statement for an existing table in the database? Regards, Jack
8
2444
by: matt | last post by:
hello, can anyone speak to some of the common or preferred methods for building Excel .XLS files, programmatically thru the .NET framework? i have an intranet app that needs to generate &...
5
1810
by: Arun Srinivasan | last post by:
I am trying to generate sql from sql. Like select 'select count(*) from ' || tabschema ..............syscat.tables where.....; is there a way to run this with a single statement? I tried with...
1
620
by: Jack Miller | last post by:
Hi, Is there any SQL command in Oracle that returns a "CREATE TABLE" statement in Oracle. For example in MySQL there is a command called "SHOW CREATE TABLE <tableName>" This command can be...
0
7037
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
1
6730
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
6873
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5321
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4471
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2990
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
2976
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
558
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
174
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.