In PD, double-click a table and view its preview label. Then, the create statement of a table is displayed as follows:
Copy codeThe 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:Copy codeThe 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.
