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.
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.