Alter table to add primary key with tablespace and storage setting : Alter Table « Table « Oracle PL/SQL Tutorial






SQL>
SQL> create table employee_job (
  2  id                             number                         not null,
  3  worker_id                      number                         not null,
  4  logical_workplace_id           number                         not null,
  5  active_date                    date          default SYSDATE  not null,
  6  inactive_date                  date )
  7  tablespace USERS pctfree 20
  8  storage (initial 10K next 10K pctincrease 0);

Table created.

SQL>
SQL>
SQL> alter  table employee_job add
  2  constraint   employee_job_PK
  3  primary key ( id )
  4  using index
  5  tablespace USERS pctfree 20
  6  storage (initial 10K next 10K pctincrease 0);

Table altered.

SQL>
SQL> drop table employee_job;

Table dropped.

SQL>








6.3.Alter Table
6.3.1.Altering a Table
6.3.2.Some of the aspects of a column you can modify using ALTER TABLE
6.3.3.Adding a Column
6.3.4.ADD initially_created DATE DEFAULT SYSDATE NOT NULL;
6.3.5.Changing the Size of a Column
6.3.6.Decrease the length of a column
6.3.7.Changing the Precision of a Numeric Column
6.3.8.Decrease the precision of a numeric column
6.3.9.Changing the Data Type of a Column
6.3.10.Fill data into new added table column
6.3.11.Changing the Default Value of a Column
6.3.12.Alter table to add new constraint for new added column
6.3.13.ALTER TABLE to DISABLE a CONSTRAINT
6.3.14.Alter table to add primary key
6.3.15.Alter table to add primary key across more than one columns
6.3.16.Dropping a Column
6.3.17.New added columns are empty
6.3.18.Alter table to add unique with tablespace and storage setting
6.3.19.Alter table to add primary key with tablespace and storage setting
6.3.20.alter table nologging