|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: ALTER
Definition: ALTER TABLE table_old_name To add a column to a table, the syntax is: ALTER TABLE table_name For example: ALTER TABLE users You may add multiple columns with a single ALTER statement. Each column must have its own definition. The ALTER TABLE syntax to DROP a column is: ALTER TABLE table_name For example: ALTER TABLE users In Oracle 9i and above, you can use the ALTER statement along with the RENAME statement to change the name of a table column. Example syntax is shown here: ALTER TABLE users Related Links: Related Code Snippets:
|
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |