ApexERPHost

GetDbServerTableInfo

**Requires Authentication**
Required role:	SysAdmin

The following routes are available for this service:
GET	/dbadmin/servers/databases/tableinfo
GET	/dbadmin/servers/{ServerId}/databases/tableinfo

**GetDbServerTableInfo** Parameters:
Name	Parameter	Data Type	Required
ServerId	path	string	No
DbName	query	string	No
Schema	query	string	No
Name	query	string	No

**GetDbServerTableInfoResponse** Parameters:
Name	Parameter	Data Type	Required	Description
ResponseStatus	form	ResponseStatus	No
Result	form	List<DbServerTableInfo>	No

**DbServerTableInfo** Parameters:
Name	Parameter	Data Type	Required
Schema	form	string	No
Name	form	string	No
Owner	form	string	No
DataKB	form	int	No
RowCount	form	int	No
value	form	string	No
IndexKB	form	int	No
HasClusIdx	form	bool	No
Columns	form	int	No
create_date	form	DateTime	No
modify_date	form	DateTime	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /dbadmin/servers/databases/tableinfo HTTP/1.1 
Host: apex.nikoratrade.ge 
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<GetDbServerTableInfoResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Apex.Services.DbAdmin">
  <ResponseStatus xmlns:d2p1="http://schemas.servicestack.net/types">
    <d2p1:ErrorCode>String</d2p1:ErrorCode>
    <d2p1:Message>String</d2p1:Message>
    <d2p1:StackTrace>String</d2p1:StackTrace>
    <d2p1:Errors>
      <d2p1:ResponseError>
        <d2p1:ErrorCode>String</d2p1:ErrorCode>
        <d2p1:FieldName>String</d2p1:FieldName>
        <d2p1:Message>String</d2p1:Message>
        <d2p1:Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </d2p1:Meta>
      </d2p1:ResponseError>
    </d2p1:Errors>
    <d2p1:Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </d2p1:Meta>
  </ResponseStatus>
  <Result>
    <DbServerTableInfo>
      <Schema>String</Schema>
      <Name>String</Name>
      <Owner>String</Owner>
      <DataKB>0</DataKB>
      <RowCount>0</RowCount>
      <value>String</value>
      <IndexKB>0</IndexKB>
      <HasClusIdx>false</HasClusIdx>
      <Columns>0</Columns>
      <create_date>0001-01-01T00:00:00</create_date>
      <modify_date>0001-01-01T00:00:00</modify_date>
    </DbServerTableInfo>
  </Result>
</GetDbServerTableInfoResponse>