Oracle SQL Developer - How To Get a CREATE Statement for an Existing Table
Interview Question Database For Software Developers
|
|
| 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 | | By: 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:
- Double-click the table name JOBS in the object tree area.
- Click the SQL tab in the object view area.
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")
;
| | ID: 568 | Rank: 1206 | Votes: 0 | Views: 47 | Submitted: 20070427 |
Copyright © 2010 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view