If a database table do not have any primary key, then how we can handle this table in Appian CDT?
Discussion posts and replies are publicly visible
Not. Appian requires a primary key. If you do not have one, you could create a view that adds an artificial PK.
How can we update the data in that table if we are creating the view?
If you are creating a view, simply add a new column for the artificial or composite key.
CREATE VIEW my_view AS SELECT col1, col2, CONCAT(col1, '_', col2) AS composite_key FROM my_table;
We cannot update data in view, data should be update in the Table then how we can update the table?
If you are going to update the table, then why not just add an auto-increment id column?
Why do you have one table without a primary key? Add it with autoincrement at least , and you will we able to create your cdt.
ankitas209 said:then how we can handle this table in Appian
By updating it to add a Primary Key column.