Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

classinfo


Description

Get the information of tables from a database.

Request Json Syntax

 

Key Description
task task name
token token string encrypted.
dbname database name
dbstatus N/A

 

Request Sample

 

{
  "task":"classinfo",
  "token":"cdfb4c5717170c5ed30ef86644baf8151531ce5adff4a1f9a54711c51e0f50767926f07dd201b6aa",
  "dbname":"demodb",
  "dbstatus":"on"
}

 

Response Json Syntax

Key Description
task task name
status execution result, success or failed.
note if failed, a brief description will be given here
dbname database name
systemclass system class information list
classname class name
owner class owner
userclass user class info list

Response Sample

 

{
   "__EXEC_TIME" : "271 ms",
   "dbname" : "testdb",
   "note" : "none",
   "status" : "success",
   "systemclass" : 
      {
         "class" : [
            {
               "classname" : "db_root",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_user",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_password",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_authorization",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_authorizations",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_trigger",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_class",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_attribute",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_domain",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_method",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_meth_sig",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_meth_arg",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_meth_file",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_query_spec",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_index",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_index_key",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_data_type",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_auth",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_partition",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_stored_procedure",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "_db_stored_procedure_args",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_serial",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_ha_apply_info",
               "owner" : "DBA",
               "virtual" : "normal"
            },
            {
               "classname" : "db_class",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_direct_super_class",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_vclass",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_attribute",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_attr_setdomain_elm",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_method",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_meth_arg",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_meth_arg_setdomain_elm",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_meth_file",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_index",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_index_key",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_auth",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_trig",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_partition",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_stored_procedure",
               "owner" : "DBA",
               "virtual" : "view"
            },
            {
               "classname" : "db_stored_procedure_args",
               "owner" : "DBA",
               "virtual" : "view"
            }
         
      }
   ],
   "task" : "classinfo",
   "userclass" : 
      {
         "class" : [
            {
               "classname" : "table1",
               "owner" : "PUBLIC",
               "virtual" : "normal"
            },
            {
               "classname" : "table2",
               "owner" : "PUBLIC",
               "virtual" : "normal"
            }
         
      }
   ]
}
comments powered by Disqus
Page info
viewed 377 times
translations en
Author
posted last year by
cheeray
Contributors
updated last year by
View revisions
Share this article