I am downloading database script through record types data model' generate database script. It gives both create sequence and create table scripts . In the create sequence the sequence structure is TABLE_NAME_sq. The sq value is in lowercase . But if check in the record fileds primary key edit option it's showing in Uppercase like SQ. So which one should I consider when generating scripts for deploy to other environment. The things the application I'm about to deploy in completely new and we use oracle database which I'm not familiar with so I'm confused.
Discussion posts and replies are publicly visible
In Oracle, unless identifiers (table names, sequence names) are enclosed in double quotes, the database treats them as case-insensitive and stores them as UPPERCASE by default.
If your script says CREATE SEQUENCE my_table_sq, Oracle stores it as MY_TABLE_SQ.
When Appian looks at the database, it sees MY_TABLE_SQ and displays it that way in the UI.
The Verdict: The difference between _sq in the script and _SQ in the Record Type UI is usually just a visual representation. They point to the same object.