| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | Notes |
|---|---|---|---|---|
| TDC | dbo | dtproperties | BASE TABLE | |
| TDC | dbo | sysconstraints | VIEW | |
| TDC | dbo | syssegments | VIEW | |
| TDC | dbo | TDC_approve_object_type | BASE TABLE | |
| TDC | dbo | TDC_approve_packet_def | BASE TABLE | |
| TDC | dbo | TDC_approve_packet_detail | BASE TABLE | |
| TDC | dbo | TDC_arc_apprpkt_def | BASE TABLE | |
| TDC | dbo | TDC_arc_apprpkt_detail | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_comments | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_packets | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_route_def | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_route_def_approv | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_route_step_def | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_route_step_detai | BASE TABLE | |
| TDC | dbo | TDC_arc_inpr_route_step_statu | BASE TABLE | |
| TDC | dbo | TDC_arc_inprpkt_vault_cha | BASE TABLE | |
| TDC | dbo | TDC_chg_request | BASE TABLE | |
| TDC | dbo | TDC_collab_del | BASE TABLE | |
| TDC | dbo | TDC_collab_docfile | BASE TABLE | |
| TDC | dbo | TDC_collab_newfile | BASE TABLE | |
| TDC | dbo | TDC_collab_subfile | BASE TABLE | |
| TDC | dbo | TDC_collab_version | BASE TABLE | |
| TDC | dbo | TDC_doc_accesscattype | BASE TABLE | |
| TDC | dbo | TDC_doc_attrib | BASE TABLE | "DEFAULT" |
| TDC | dbo | TDC_doc_checkout | BASE TABLE | |
| TDC | dbo | TDC_doc_checkouttype | BASE TABLE | |
| TDC | dbo | TDC_doc_controlled_copies | BASE TABLE | |
| TDC | dbo | TDC_doc_customfield_data | BASE TABLE | |
| TDC | dbo | TDC_doc_customfield_date | BASE TABLE | |
| TDC | dbo | TDC_doc_customfield_lookup | BASE TABLE | |
| TDC | dbo | TDC_doc_customfield_names | BASE TABLE | |
| TDC | dbo | TDC_doc_customfield_number | BASE TABLE | |
| TDC | dbo | TDC_doc_customfield_time | BASE TABLE | |
| TDC | dbo | TDC_doc_document_type | BASE TABLE | |
| TDC | dbo | TDC_doc_file | BASE TABLE | Actual file as blob |
| TDC | dbo | TDC_doc_file_children | BASE TABLE | |
| TDC | dbo | TDC_doc_file_internet | BASE TABLE | |
| TDC | dbo | TDC_doc_file_location | BASE TABLE | |
| TDC | dbo | TDC_doc_icon | BASE TABLE | |
| TDC | dbo | TDC_doc_infocard | BASE TABLE | Infocard data |
| TDC | dbo | TDC_doc_lastact | BASE TABLE | |
| TDC | dbo | TDC_doc_linked | BASE TABLE | |
| TDC | dbo | TDC_doc_locked | BASE TABLE | locked files/infocards |
| TDC | dbo | TDC_doc_locktype | BASE TABLE | defines types of locks (i.e. "In Process") |
| TDC | dbo | TDC_doc_reference | BASE TABLE | |
| TDC | dbo | TDC_doc_reference_type | BASE TABLE | |
| TDC | dbo | TDC_doc_release | BASE TABLE | |
| TDC | dbo | TDC_doc_reltype | BASE TABLE | |
| TDC | dbo | TDC_doc_thumbnail | BASE TABLE | |
| TDC | dbo | TDC_edcd_converted | BASE TABLE | |
| TDC | dbo | TDC_inprocess_appr | BASE TABLE | |
| TDC | dbo | TDC_inprocess_comments | BASE TABLE | |
| TDC | dbo | TDC_inprocess_packet_vault_cha | BASE TABLE | |
| TDC | dbo | TDC_inprocess_packets | BASE TABLE | |
| TDC | dbo | TDC_inprocess_route_def | BASE TABLE | |
| TDC | dbo | TDC_inprocess_route_def_approv | BASE TABLE | |
| TDC | dbo | TDC_inprocess_route_step_def | BASE TABLE | |
| TDC | dbo | TDC_inprocess_route_step_detai | BASE TABLE | |
| TDC | dbo | TDC_inprocess_route_step_statu | BASE TABLE | |
| TDC | dbo | TDC_message_server_def | BASE TABLE | |
| TDC | dbo | TDC_module | BASE TABLE | |
| TDC | dbo | TDC_org_checkout | BASE TABLE | |
| TDC | dbo | TDC_org_def | BASE TABLE | |
| TDC | dbo | TDC_org_def_checked_out | BASE TABLE | |
| TDC | dbo | TDC_org_detail | BASE TABLE | |
| TDC | dbo | TDC_org_heading_detail | BASE TABLE | |
| TDC | dbo | TDC_org_headings | BASE TABLE | |
| TDC | dbo | TDC_org_project_step_detail | BASE TABLE | |
| TDC | dbo | TDC_org_project_step_notes | BASE TABLE | |
| TDC | dbo | TDC_org_project_steps | BASE TABLE | |
| TDC | dbo | TDC_org_projects | BASE TABLE | |
| TDC | dbo | TDC_org_rules | BASE TABLE | |
| TDC | dbo | TDC_org_system_rules | BASE TABLE | |
| TDC | dbo | TDC_publish_que | BASE TABLE | |
| TDC | dbo | TDC_published_del | BASE TABLE | |
| TDC | dbo | TDC_published_doc | BASE TABLE | |
| TDC | dbo | TDC_published_pdf | BASE TABLE | |
| TDC | dbo | TDC_req_info_fields | BASE TABLE | |
| TDC | dbo | TDC_route_action | BASE TABLE | |
| TDC | dbo | TDC_route_def_approval | BASE TABLE | |
| TDC | dbo | TDC_route_packet_vault_change | BASE TABLE | |
| TDC | dbo | TDC_route_status | BASE TABLE | |
| TDC | dbo | TDC_route_status_action | BASE TABLE | |
| TDC | dbo | TDC_route_step_def | BASE TABLE | |
| TDC | dbo | TDC_route_step_details | BASE TABLE | |
| TDC | dbo | TDC_route_step_status_action | BASE TABLE | |
| TDC | dbo | TDC_route_type | BASE TABLE | |
| TDC | dbo | TDC_routing_def | BASE TABLE | |
| TDC | dbo | TDC_routing_system_setup | BASE TABLE | |
| TDC | dbo | TDC_ses_accesscats | BASE TABLE | |
| TDC | dbo | TDC_status_action | BASE TABLE | |
| TDC | dbo | TDC_sys_doctypes | BASE TABLE | Doctypes (Acrobat, AutoCAD, etc) |
| TDC | dbo | TDC_sys_group_access_cat | BASE TABLE | |
| TDC | dbo | TDC_sys_group_user | BASE TABLE | |
| TDC | dbo | TDC_sys_inproc_lock | BASE TABLE | |
| TDC | dbo | TDC_sys_mail_parms | BASE TABLE | |
| TDC | dbo | TDC_sys_mapping | BASE TABLE | |
| TDC | dbo | TDC_sys_messages | BASE TABLE | |
| TDC | dbo | TDC_sys_modfunc_def | BASE TABLE | |
| TDC | dbo | TDC_sys_module | BASE TABLE | |
| TDC | dbo | TDC_sys_msg_lock | BASE TABLE | |
| TDC | dbo | TDC_sys_natview | BASE TABLE | |
| TDC | dbo | TDC_sys_notify_def | BASE TABLE | |
| TDC | dbo | TDC_sys_notify_lst | BASE TABLE | |
| TDC | dbo | TDC_sys_number_doc_types | BASE TABLE | |
| TDC | dbo | TDC_sys_number_series | BASE TABLE | |
| TDC | dbo | TDC_sys_ostype | BASE TABLE | os_id is NT or WIN |
| TDC | dbo | TDC_sys_parameters | BASE TABLE | |
| TDC | dbo | TDC_sys_sec_function | BASE TABLE | |
| TDC | dbo | TDC_sys_sqlexpr | BASE TABLE | |
| TDC | dbo | TDC_sys_user | BASE TABLE | User/password, email, etc. |
| TDC | dbo | TDC_sys_workgroup | BASE TABLE | |
| TDC | dbo | TDC_web_viewed | BASE TABLE |
Some sample commands:
Update TDC_doc_infocard set access_category_id="SYSTEM DRAFT" where info_card_id="201008041030203946"
delete from TDC_doc_locked where info_card_id=201008041030203946