Collections:
Retrieve CREATE TABLE Statement with SQL Developer in Oracle
How To Get a CREATE Statement for an Existing Table in Oracle?
✍: 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") ;
⇒ Create a Table Interactively in Oracle
⇐ Work with Data Objects Interactively in Oracle
2018-10-08, 1675🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...