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, 2022🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...