Generated By Application Designer For Alter By Table Rename SYNTAX Command
Hi All,
We are always facing issues with RENAME SYNTAX command getting auto-generated in PSBUILD.SQL while BUILD with ALTER table option via application designer. Please refer attached video file for your reference.
Example :
RENAME TABLENAME TO PS_AP_EXTRACT_LINE
will be
ALTER TABLENAME RENAME TO PS_AP_EXTRACT_LINE
Please check and assists on this quickly?
While BUILD and execute Alter via application designer doesn't have an issue with RENAME, issues with only BUILD script (PSBUILD.SQL) generates via application designer it includes the extra command "RENAME" and running in PL SQL backend DB.
Always DBA team was edit RENAME in the place of an actual table name ( refer above example ) and running it. it's very difficult always for them to do it.