Αποτελέσματα Αναζήτησης
RENAME TABLE invalidates any packages that are dependent on the source table. RENAME INDEX invalidates any packages that are dependent on the source index. If an alias is used for the source-table-name, it must resolve to a table name. The table is renamed within the schema of this table.
The RENAME COLUMN clause is an option on the ALTER TABLE statement. You can rename an existing column in a base table to a new name without losing stored data or affecting any privileges or label-based access control (LBAC) policies that are associated with the table.
To change the name of an existing table to a new one, you use the RENAME TABLE statement. Here is the syntax of the RENAME TABLE statement: RENAME TABLE table_name TO new_table_name; Code language: SQL (Structured Query Language) ( sql )
if you want to rename a table in the same schema, you can use like this. RENAME TABLE schema.table_name TO "new_table_name"; Otherwise, you can use tools like DBeaver to rename or copy tables in a db2 db.
5 Ιουλ 2013 · Run a db2look on that table to obtain all references, and backup this DDL. Delete all constraints, and drop all triggers referencing the table. Rename your table. Use the DDL, change it to point to the new table name, and recreate the dependencies
Db2 ALTER TABLE ALTER COLUMN allows you to modify the definitions of the existing columns in a table. The following illustrates the syntax of the ALTER TABLE ALTER COLUMN statement: ALTER TABLE table_name ALTER COLUMN column_name modification_type; Code language: SQL (Structured Query Language) (sql) In this syntax:
The RENAME TABLE statement returns an error if the target table is referenced in a view definition or an SQL table function, unless the RENAMETABLE subsystem parameter is set to ALLOW_DEP_VIEW_SQLTUDF.
