What are the limitations of Alter Table command?

Explain the use of Alter Table command. Explain with an example.

ALTER table command is used to modify a table’s column attributes, renaming a table or column etc.

Example:
Add column to an existing table
ALTER table student ADD COLUMN department varchar(100);

Rename a table
ALTER table student RENAME TO studentdata;

What are the limitations of Alter Table command?

- Column can’t be deleted with alter command.
- Column can’t be renamed a column.
- Column can’t be added in between of the existing columns.
- When a column is added, it will be added at the end of the table.
Explain types of tables in oracle
In Oracle, tables are the basic storage units. There are several types of database tables. Different types of tables have different characteristics.....
Global temporary tables
The maintenance and management of temporary tables can be delegated to the server by using Global Temporary Tables.......
What is Nested Table?
What is Nested Table? - Nested Table is a table inside a table. It can have several rows for each row of its parent table..
Post your comment

Related Content

Follow us

▲