Symptoms
The client created a smartobject, but he was not able to see the smartobject in the database anywhere. He requested some additiona information about where smartobjects gets stored.
Diagnoses
When you build a smartbox smartobject, then we create a table for it in the K2 DB. For a list of smartbox smartobjects, you can go have a peek at the [K2].[Smartbox].[SmartboxObject] table.
If it is a non-smartbox smartobject, (IE SQL, SharePoint, CRM) you can find the definition in the SmartBroker.SmartObject table.
Please note that this is just the smartobject definition. The data is still stored in the "data provider".
Resolution
The client created a smartbox smartobject called "XYZ" and renamed it in Visual Studio to smoXYZ. This will cause the display name to get updated, but the system name will still stay the same. The client was looking for the table name in the K2 DB using smoXYZ.