Αποτελέσματα Αναζήτησης
To rename a table, you use the following Oracle RENAME table statement as follows: RENAME table_name TO new_name; Code language: SQL (Structured Query Language) (sql) In the RENAME table statement: First, specify the name of the existing table which you want to rename. Second, specify the new table name.
- PRIMARY KEY
ALTER TABLE table_name DISABLE CONSTRAINT...
- PRIMARY KEY
7 Μαΐ 2009 · To rename a table you can use: RENAME mytable TO othertable; or. ALTER TABLE mytable RENAME TO othertable; or, if owned by another schema: ALTER TABLE owner.mytable RENAME TO othertable; Interestingly, ALTER VIEW does not support renaming a view. You can, however: RENAME myview TO otherview;
Rename table Syntax. To RENAME A TABLE, the Oracle ALTER TABLE syntax is: ALTER TABLE table_name RENAME TO new_table_name; Example. Let's look at an example that shows how to rename a table in Oracle using the ALTER TABLE statement. For example: ALTER TABLE customers RENAME TO contacts;
Use the RENAME statement to rename a table, view, sequence, or private synonym. Oracle Database automatically transfers integrity constraints, indexes, and grants on the old object to the new object.
RENAME TABLE allows you to rename an existing table in any schema (except the schema SYS). To rename a table, you must either be the database owner or the table owner.
Use the RENAME clause to rename table to new_table_name. Using this clause invalidates any dependent materialized views. For more information on materialized views, see CREATE MATERIALIZED VIEW and Oracle Database Data Warehousing Guide.
The ALTER TABLE statement allows you to: Add one or more columns. Modify column definition. Drop one or more columns. Rename columns. Rename table. Let’s see some examples to understand how each action works. Oracle ALTER TABLE examples. We will use the persons table that we created in the previous tutorial for the demonstration.
