This article will introduce how to change the create Statement of oracle to the alter statement. For more information, see
This article will introduce how to change the create Statement of oracle to the alter statement. For more information, see
In PD, double-click a table and view its preview label. Then, the create statement of a table is displayed as follows:
The Code is as follows:
Create table Company_Info (
Company_ID NVARCHAR2 (50) not null,
Area_ID NVARCHAR2 (50 ),
Mem_ID NVARCHAR2 (50 ),
Level_Id NVARCHAR2 (50 ),
Name NVARCHAR2 (50) not null,
Capital NVARCHAR2 (50 ),
Unit_Property NUMBER (2) not null,
Economical mics_type NUMBER (2) not null,
Man_Scale NUMBER (10, 0 ),
License_Code NVARCHAR2 (50 ),
License_Img NVARCHAR2 (50 ),
Intro NVARCHAR2 (3000 ),
Company_Img NVARCHAR2 (200 ),
Address NVARCHAR2 (200 ),
Postal_Code NVARCHAR2 (50 ),
Tel NVARCHAR2 (50 ),
Fax NVARCHAR2 (50 ),
Mobile NVARCHAR2 (50) not null,
Email NVARCHAR2 (50) not null,
Contactor_sex NUMBER (2 ),
Contactor NVARCHAR2 (50 ),
Web_Site NVARCHAR2 (200 ),
View_Count NUMBER (20, 0 ),
Create_Date DATE not null,
Update_Date DATE not null,
Status NUMBER (2 ),
Company_Type NUMBER (2 ),
Remain_Point NUMBER (6, 0 ),
Cmp_Level NVARCHAR2 (50 ),
IsAdv NUMBER (2 ),
Expri_Date DATE,
Display_index NUMBER (6, 0 ),
Constraint PK_COMPANY_INFO primary key (Company_ID)
);
If we add some fields and add these fields to the original database, we can: change create to alter, and then replace
Field removal:
The Code is as follows:
Alter table Company_Info add (
Remain_Point NUMBER (6, 0 ),
Cmp_Level NVARCHAR2 (50 ),
IsAdv NUMBER (2 ),
Expri_Date DATE,
Display_index NUMBER (6, 0)
)
This accelerates our development efficiency.
