Difference between revisions of "Table Creation and Management"
Jump to navigation
Jump to search
(Created page with ";Identify the table name and structure ;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 d...") |
|||
| Line 1: | Line 1: | ||
;Identify the table name and structure | ;Identify the table name and structure | ||
: Commands used to create or modify database tables are called '''data definition language(DDL''' | |||
;Create a new table with the CREATE TABLE command | ;Create a new table with the CREATE TABLE command | ||
;Use a subquery to create a new table | ;Use a subquery to create a new table | ||
Revision as of 22:37, 29 September 2017
- Identify the table name and structure
- Commands used to create or modify database tables are called data definition language(DDL
- 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