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 .jsv suffix or ?format=jsv

HTTP + JSV

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: text/jsv

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	ResponseStatus: 
	{
		ErrorCode: String,
		Message: String,
		StackTrace: String,
		Errors: 
		[
			{
				ErrorCode: String,
				FieldName: String,
				Message: String,
				Meta: 
				{
					String: String
				}
			}
		],
		Meta: 
		{
			String: String
		}
	},
	Result: 
	[
		{
			Schema: String,
			Name: String,
			Owner: String,
			DataKB: 0,
			RowCount: 0,
			value: String,
			IndexKB: 0,
			HasClusIdx: False,
			Columns: 0,
			create_date: 0001-01-01,
			modify_date: 0001-01-01
		}
	]
}