This section contains articles about the EQuIS views developed by EarthSoft, Inc.
In a SQL database, a view is a virtual table (not saved to the database) based on the output of a SQL statement, similar to a report output. They are not editable and are used to view data or report it more efficiently. Rows within a view do not count towards the total number of rows in a database. For information on creating a custom view for a database, see Create Custom View.
In EQuIS Professional, access Views from the Open window:
The following views are part of the standard (i.e. EQuIS Professional, Enterprise, and StandardReports) EQuIS Schema:
CM_tsconc CM_tssoildepth st_id st_report_use st_user_facility st_user_role vw_audit |
vw_coord_non_numeric vw_db_version vw_downhole_data vw_geography_point vw_group_member_tree vw_lithology vw_lithology_gap_overlap |
vw_location vw_result_non_numeric vw_table_column vw_table_order vw_table_row_count vw_well vw_well_segment |
Note: If VW_TABLE_ROW_COUNT returns the error, "VIEW DATABASE PERFORMANCE STATE permission denied in database", the database administrator should run the following on the database:
GRANT VIEW DATABASE PERFORMANCE STATE to ES_PUBLIC |