Difference between revisions of "Table Creation and Management"

From rbachwiki
Jump to navigation Jump to search
Line 5: Line 5:
!Creating Tables
!Creating Tables
!Description
!Description
|-
| CREATE TABLE
| CREATE TABLE
| Creates a new table in the database. The user names the columns and identifies the type of data to be stored. To view a table, use the SQL*PLUS
| Creates a new table in the database. The user names the columns and identifies the type of data to be stored. To view a table, use the SQL*PLUS

Revision as of 22:44, 29 September 2017

Identify the table name and structure
Commands used to create or modify database tables are called data definition language(DDL commands
A Database Object is a defined self contained structure also called database tables
Creating Tables Description
CREATE TABLE Creates a new table in the database. The user names the columns and identifies the type of data to be stored. To view a table, use the SQL*PLUS

command DESCRIBE.

Create a new table with the CREATE TABLE command
Use a subquery to create a new table
Add a column to an existing table
Modify the definition of a column in an existing table
Delete a column from an existing table
Mark a column as unused and then delete it later
Rename a table
Truncate a table
Drop a table