What are the limitation of alter command?

What are the limitations of alter command?

- ALTER Command supports only the RENAME TABLE and ADD COLUMN variants.
- Other kinds of ALTER TABLE operations such as DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT are omitted.
- 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 Alter Table Command
Alter Table command is a DDL command that is used to change the definition of the table....
What are the limitations of Alter Table command?
Column can’t be deleted with alter command. Column can’t be renamed a column.....
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.....
Post your comment

Related Content

Follow us

▲