Cache DDL syntax to rename a Table
Hi All, I am a Data Architect and am trying a method of deploying alter statements onto Cache DB.
My Data Modeling tool generates alters as this.. So question is if the Cache has a way to rename table? If so what is it?
ALTER TABLE <SchemaName>.GROUP_TYPE_NODES RENAME TO GROUP_TYPE_10082019140110000
;
This is giving error.
SQL Error [25] [37000]: [SQLCODE: <-25>:<Input encountered after end of query>]
[Location: <Prepare>]
[%msg: < Input (IDENTIFIER) encountered after end of query^ALTER TABLE xxx.GROUP_TYPE_NODES RENAME>]