| Info |
|---|
Remote SQL access grants programmers access to raw data in a Microsoft SQL Server database and is only available for Cloud customers. CXT Software provides several options of accessing data such as those listed in Data Reporting Options for the Operations App, and remote SQL access is often used as a last resort when other options are not viable. Please speak with Client Success for more information about this feature. |
...
Database objects such as tables, stored procedures, and views, can be created in the cusdbo schema only. See Object Naming Policy below.
Read/write/update/delete "data only" in any table is permitted within both the cusdbo and dbo schemas.
It is recommended to clean up old, expired data as needed, in set intervals as excessive table data storage can and will have an adverse effect on database performance.
...
Views - Prefix: vw
cusdbo.CUSTOM_ID_vwViewName
Tables - Prefix: tbl
cusdbo.CUSTOM_ID_tblTableName
Stored Procedures - Prefix: sp
cusdbo.CUSTOM_ID_spStoredProcedureName
Completed examples: cusdbo.CUSTOM_9999_tblCustomTable or cusdbo.CUSTOM_9999_spGetSomething
...