Loading...

System Views

SYS_Objects


Returns information about Solution objects.

Example

SELECT [ObjectID]
,[Name]
,[SolutionID]
,[ObjectType]
,[ObjectSubType]
,[WorkProcess_ID]
,[WorkProcess_Name]
,[WorkProcessVersion_ID]
,[WorkProcessVersion_Name]
FROM [SYS_Objects]

SYS_WorkProcessVersions


Returns information about Work Processes and Work Process Versions.

Example

SELECT [WorkProcess_ID]
,[WorkProcess_Name]
,[WorkProcessVersion_ID]
,[WorkProcessVersion_Name]
FROM [SYS_WorkProcessVersions]

SYS_Solutions


Returns information about Solutions.

Example

SELECT [SolutionID]
,[Name]
,[WorkProcess_ID]
,[WorkProcess_Name]
,[WorkProcessVersion_ID]
,[WorkProcessVersion_Name]
FROM [SYS_Solutions]

SYS_Tables


Returns information about all tables and views in Solutions.

Example

SELECT [TableName]
,[ObjectID]
,[SolutionID]
,[MetaType]
,[TableType]
,[WorkProcess_ID]
,[WorkProcess_Name]
,[WorkProcessVersion_ID]
,[WorkProcessVersion_Name]
FROM [SYS_Tables]