<< Click to Display Table of Contents >> Navigation:  Supported database systems > Microsoft SQL Server > Database schema (SQL Server)

You can use this query to select information about the tables used by Dispatch:

 

SELECT

TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

TABLE_NAME LIKE 'dsptch30_%' OR TABLE_NAME LIKE 'receipt_ticket%' OR TABLE_NAME LIKE 'shipment_ticket%'

ORDER BY TABLE_NAME

Server properties

https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql