Symptoms

CRUD (Create, Update, Delete) methods are not exposed for newly created SQL Service SmO while target table(s) has primary key.
 

Diagnoses

Primary key is compulsory to have CRUD (Create, Update, Delete) methods. As per K2 documentation: "Service Objects for Tables that contain a Primary Key column will contain all the CRUD (Create, Read, Update, Delete) methods, as well as LIST. If there is no primary key on the table then only a List method will be created." In case when your table has primary key but CRUD methods are still not exposed, then it most likely can be caused by "." in a table name. To resolve this remove "." from table name and refresh your service instance and SmOs.
 

Resolution

This issue can be caused by absence of primary key on the table or by "." in the table name. In case of "." in table name this can be resolved by renaming table with subsequent SI/SmO refresh.