Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Get a CREATE Statement for an Existing Table
How To Get a CREATE Statement for an Existing Table? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
You have an existing table and want to get a CREATE statement for that table, you can use the SQL tab in the object view. The following tutorial steps show you how to use SQL Developer to generate a CREATE statement on an existing table:
In a moment, you will get the following CREATE statements:
REM HR JOBS CREATE TABLE "HR"."JOBS" ( "ID" VARCHAR2(10 BYTE), "TITLE" VARCHAR2(35 BYTE) CONSTRAINT "TITLE_NN" NOT NULL ENABLE, "MIN_SALARY" NUMBER(6,0), "MAX_SALARY" NUMBER(6,0), CONSTRAINT "ID_PK" PRIMARY KEY ("ID") ENABLE ) ; REM HR ID_PK CREATE UNIQUE INDEX "HR"."ID_PK" ON "HR"."JOBS" ("ID") ;
2007-04-27, 4795👍, 0💬
Popular Posts:
What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...
Describe in detail Basic of SAO architecture of Remoting? For these types of questions interviewer e...
Can we have shared events ? Yes, you can have shared event’s note only shared methods can raise shar...
How To Analyze Tables with "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Serve...
Which is the best place to store ConnectionString in Dot Net Projects? I am about to deploy my first...