EndPoint Get List of System Tables - Admin (Use sys_db_object)

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_system_tables_admin

Description

Get a list of tables created by 'system' user [API reference]

Parameters

Parameter	Label	Required	Options	Description
PagingRowCount	Page Size (Default=2000, Max=10000)	YES		Max can be 10000 but it may decrease performance if you fetching less than 10K rows in some requests.
SysId	SysId	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
sys_id	`DT_WSTR`	`nvarchar(500)`	500	False
name	`DT_WSTR`	`nvarchar(500)`	500	False
label	`DT_WSTR`	`nvarchar(500)`	500	False
sys_name	`DT_WSTR`	`nvarchar(500)`	500	False
create_access	`DT_WSTR`	`nvarchar(50)`	50	False
alter_access	`DT_WSTR`	`nvarchar(50)`	50	False
access	`DT_WSTR`	`nvarchar(500)`	500	False
live_feed_enabled	`DT_WSTR`	`nvarchar(50)`	50	False
sys_updated_on	`DT_DBTIMESTAMP`	`datetime`		False
sys_class_name	`DT_WSTR`	`nvarchar(500)`	500	False
is_extendable	`DT_WSTR`	`nvarchar(50)`	50	False
user_role	`DT_WSTR`	`nvarchar(500)`	500	False
create_access_controls	`DT_WSTR`	`nvarchar(50)`	50	False
delete_access	`DT_WSTR`	`nvarchar(50)`	50	False
sys_updated_by	`DT_WSTR`	`nvarchar(100)`	100	False
sys_class_path	`DT_WSTR`	`nvarchar(500)`	500	False
sys_created_on	`DT_DBTIMESTAMP`	`datetime`		False
caller_access	`DT_WSTR`	`nvarchar(500)`	500	False
client_scripts_access	`DT_WSTR`	`nvarchar(50)`	50	False
extension_model	`DT_WSTR`	`nvarchar(500)`	500	False
actions_access	`DT_WSTR`	`nvarchar(50)`	50	False
sys_scope_link	`DT_WSTR`	`nvarchar(1000)`	1000	False
sys_scope_value	`DT_WSTR`	`nvarchar(500)`	500	False
sys_created_by	`DT_WSTR`	`nvarchar(100)`	100	False
sys_class_code	`DT_WSTR`	`nvarchar(500)`	500	False
read_access	`DT_WSTR`	`nvarchar(50)`	50	False
super_class	`DT_WSTR`	`nvarchar(500)`	500	False
sys_mod_count	`DT_WSTR`	`nvarchar(50)`	50	False
ws_access	`DT_WSTR`	`nvarchar(50)`	50	False
update_access	`DT_WSTR`	`nvarchar(50)`	50	False
sys_package_link	`DT_WSTR`	`nvarchar(1000)`	1000	False
sys_package_value	`DT_WSTR`	`nvarchar(500)`	500	False
sys_update_name	`DT_WSTR`	`nvarchar(500)`	500	False
scriptable_table	`DT_WSTR`	`nvarchar(50)`	50	False
configuration_access	`DT_WSTR`	`nvarchar(50)`	50	False
number_ref	`DT_WSTR`	`nvarchar(500)`	500	False
sys_policy	`DT_WSTR`	`nvarchar(500)`	500	False
sys_scope	`DT_WSTR`	`nvarchar(500)`	500	False
sys_package	`DT_WSTR`	`nvarchar(500)`	500	False
super_class_link	`DT_WSTR`	`nvarchar(1000)`	1000	False
super_class_value	`DT_WSTR`	`nvarchar(500)`	500	False
number_ref_link	`DT_WSTR`	`nvarchar(1000)`	1000	False
number_ref_value	`DT_WSTR`	`nvarchar(500)`	500	False
user_role_link	`DT_WSTR`	`nvarchar(1000)`	1000	False
user_role_value	`DT_WSTR`	`nvarchar(500)`	500	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.