Mega Code Archive
Setting primary key as declaring the column
SQL>
SQL> CREATE TABLE myTable (
2 Name VARCHAR(50) PRIMARY KEY NOT NULL,
3 PhoneNo VARCHAR(15) DEFAULT 'Unknown Phone' NOT NULL
4 );
Table created.
SQL>
SQL>
SQL> drop table myTable;
Table dropped.