Updated: 2014-04-28

Version: Control 5.1

List of the tables used by Control

Tables Used Directly By Control

Account
AccountContact
AccountContactUserField
AccountUserField
Address
AddressLink
AdvQuery
AssemblyLink
CalendarLink
CalendarStatus
CatalogItem
Closeout
CommissionRate
ContactActivity
ContractPeriod
CustomerGoodsItem
CustomRange
Dashboard
DiscountTable
DiscountTableItem
DivisionData
Element
EmailActivity
Employee
EmployeeContact
EmployeeGroup
GLAccount
GoodsItemPartLink
Graphic
Inventory
InventoryLog
IOTemplate
Journal
Ledger
MarketingListItem
Part
PartInfoTemplate
PartInventoryConversion
PartUsageCard
Payment
PaymentAccount
PaymentPlan
PaymentTerms
Payroll
PayrollPaycheck
PayrollPaycheckPayItem
PayrollPayItem
PayrollPayItemLink
PayrollPTO
PayrollTaxTable
PayrollTaxTableRow
PhoneNumber
PostalCodeTaxClass
PricingElement
PricingGraphic
PricingLevel
PricingLink
PricingPlan
PricingTable
ProdModLink
ProductTaxabilityCode
ProductTaxExemptLink
Promotion
QuickProduct
RecurringActivity
ReportElement
ReportMenuItem
RuleAction
RuleActivity
RuleMacro
SalesGoal
ScheduledPayment
SecurityRightChange
SelectionList
SelectionListItem
ServiceContractType
ServiceTicketPriority
Shipments
ShippingMethod
SpeedNote
StateTaxExemptionLink
Station
Store
StoreConstant
TaxClass
TaxLink
TimeCard
TransDetail
TransDetailGraphic
TransDetailParam
TransHeader
TransHeaderUserField
TransMod
TransPart
TransTax
TransVariation
UserColumns
UserFieldDef
UserFieldLayout
UserName
UserOption
Variable
VendorTransDetail
Warehouse
TransDetailHistory
TransDetailGraphicHistory
TransDetailParamHistory
TransHeaderHistory
TransHeaderHistoryUserField
TransModHistory
TransPartHistory
TransTaxHistory
TransVariationHistory
VendorTransDetailHistory
Warden
DBSettings
Sequence

Tables Used Undirectly By Control


CCCSConfiguration

CCCSCustomer

CCCSTransactions

FedExShippingLogForShipments

UPSShippingLogForShipments

Query to pull unused tables

This query can be used to pull a list of tables in a given database that are not in the above list.

code format"sql"

select name

from sys.tables

where name not in ('dtproperties',

                 'Account', 'AccountContact', 'AccountContactUserField', 'AccountUserField',
                 'Address', 'AddressLink', 'AdvQuery', 'AssemblyLink', 'CalendarLink',
                 'CalendarStatus', 'CatalogItem', 'Closeout', 'ContactActivity', 'ContractPeriod',
                 'CustomerGoodsItem', 'CustomRange', 'Dashboard', 'DiscountTable',
                 'DiscountTableItem', 'DivisionData', 'Element', 'EmailActivity', 'Employee', 'EmployeeContact',
                 'EmployeeGroup', 'GLAccount', 'GoodsItemPartLink', 'Graphic', 'Inventory',
                 'InventoryLog', 'IOTemplate', 'Journal', 'Ledger', 'MarketingListItem', 'Part',
                 'PartInfoTemplate', 'PartInventoryConversion', 'PartUsageCard', 'Payment',
                 'PaymentAccount', 'PaymentPlan', 'PaymentTerms', 'Payroll', 'PayrollPaycheck',
                 'PayrollPaycheckPayItem', 'PayrollPayItem', 'PayrollPayItemLink', 'PayrollPTO',
                 'PayrollTaxTable', 'PayrollTaxTableRow', 'PhoneNumber', 'PostalCodeTaxClass',
                 'PricingElement', 'PricingGraphic', 'PricingLevel', 'PricingLink', 'PricingPlan',
                 'PricingTable', 'ProdModLink', 'ProductTaxabilityCode', 'ProductTaxExemptLink',
                 'Promotion', 'QuickProduct', 'RecurringActivity', 'ReportElement', 'ReportMenuItem',
                 'RuleAction', 'RuleActivity', 'RuleMacro', 'SalesGoal', 'ScheduledPayment',
                 'SecurityRightChange', 'SelectionList', 'SelectionListItem', 'ServiceContractType',
                 'ServiceTicketPriority', 'Shipments', 'ShippingMethod', 'SpeedNote',
                 'StateTaxExemptionLink', 'Station', 'Store', 'StoreConstant', 'TaxClass', 'TaxLink',
                 'TimeCard', 'TransDetail', 'TransDetailGraphic', 'TransDetailParam', 'TransHeader',
                 'TransHeaderUserField', 'TransMod', 'TransPart', 'TransTax', 'TransVariation',
                 'UserColumns', 'UserFieldDef', 'UserFieldLayout', 'UserName', 'UserOption',
                 'Variable', 'VendorTransDetail', 'Warehouse', 'CommissionRate',
                 'TransDetailHistory', 'TransDetailGraphicHistory', 'TransDetailParamHistory',
                 'TransHeaderHistory', 'TransHeaderHistoryUserField', 'TransModHistory',
                 'TransPartHistory', 'TransTaxHistory', 'TransVariationHistory',
                 'VendorTransDetailHistory', 'Warden', 'DBSettings', 'Sequence',
                 'CCCSConfiguration', 'CCCSCustomer',
                 'CCCSTransactions', 'FedExShippingLogForShipments',
                 'UPSShippingLogForShipments')

Order By name


You could leave a comment if you were logged in.