Script below is used to extract data from a microkey database using ConnectAnywhere:
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'abDueDayMonth';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\abDueDayMonth.csv'
FORMAT ASCII QUOTE '"';
select * from dba.abDueDayMonth;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\abDueDayMonth.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'abLogBillPayer';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\abLogBillPayer.csv'
FORMAT ASCII QUOTE '"';
select * from dba.abLogBillPayer;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\abLogBillPayer.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'abLogMain';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\abLogMain.csv'
FORMAT ASCII QUOTE '"';
select * from dba.abLogMain;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\abLogMain.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Account';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Account.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Account;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Account.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountApproval';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountApproval.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountApproval;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountApproval.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountApprovalStatus';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountApprovalStatus.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountApprovalStatus;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountApprovalStatus.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountingAudit';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountApprovalStatus.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountApprovalStatus;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountApprovalStatus.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountingAudit';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountingAudit.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountingAudit;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountingAudit.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountsModified';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountsModified.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountsModified;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountsModified.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountsReceivable';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountsReceivable.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountsReceivable;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountsReceivable.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountTemplates';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountTemplates.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountTemplates;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountTemplates.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AccountType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AccountType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AccountType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AchUploadAudit';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AchUploadAudit.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AchUploadAudit;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AchUploadAudit.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Acmpatyp';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Acmpatyp.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Acmpatyp;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Acmpatyp.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Acqusitions';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Acqusitions.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Acqusitions;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Acqusitions.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ADIImport';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ADIImport.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ADIImport;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ADIImport.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AdjustmentType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AdjustmentType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AdjustmentType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AdjustmentType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmCodeNotifications';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmCodeNotifications.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmCodeNotifications;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmCodeNotifications.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmConditions';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmConditions.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmConditions;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmConditions.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmGeoTag';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmGeoTag.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmGeoTag;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmGeoTag.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmGroups';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmGroups.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmGroups;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmGroups.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmLock';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmLock.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmLock;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmLock.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmPackage';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmPackage.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmPackage;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmPackage.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmQueue';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmQueue.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmQueue;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmQueue.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmQueueLock';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmQueueLock.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmQueueLock;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmQueueLock.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmRelated';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmRelated.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmRelated;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmRelated.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmStack';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmStack.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmStack;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmStack.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmStackSPA';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmStackSPA.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmStackSPA;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmStackSPA.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmSystemContacts';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmSystemContacts.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmSystemContacts;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmSystemContacts.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmSystemLIst';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmSystemLIst.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmSystemLIst;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmSystemLIst.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmSystemZones';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmSystemZones.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmSystemZones;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmSystemZones.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AlarmVideo';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmVideo.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AlarmVideo;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AlarmVideo.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AllocateREceiptParams';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AllocateREceiptParams.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AllocateREceiptParams;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AllocateREceiptParams.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ApiLog';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ApiLog.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ApiLog;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ApiLog.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Appointments';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Appointments.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Appointments;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Appointments.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AppointmentStatus';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AppointmentStatus.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AppointmentStatus;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AppointmentStatus.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ARCompareAsOf';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ARCompareAsOf.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ARCompareAsOf;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ARCompareAsOf.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ARCompareSumm';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ARCompareSumm.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ARCompareSumm;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ARCompareSumm.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Area';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Area.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Area;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Area.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AreaCode';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AreaCode.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AreaCode;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AreaCode.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AttritionType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AttritionType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AttritionType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AttritionType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoBillSummary';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoBillSummary.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoBillSummary;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoBillSummary.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoDraftInfo';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoDraftInfo.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoDraftInfo;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoDraftInfo.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoDraftLog';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoDraftLog.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoDraftLog;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoDraftLog.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoPaymentSummary';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoPaymentSummary.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoPaymentSummary;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoPaymentSummary.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoPostSummary';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoPostSummary.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoPostSummary;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoPostSummary.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoPurchaseSummary';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoPurchaseSummary.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoPurchaseSummary;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoPurchaseSummary.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'AutoServiceSummary';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoServiceSummary.csv'
FORMAT ASCII QUOTE '"';
select * from dba.AutoServiceSummary;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\AutoServiceSummary.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Bank';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Bank.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Bank;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Bank.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'BankRecHistory';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\BankRecHistory.csv'
FORMAT ASCII QUOTE '"';
select * from dba.BankRecHistory;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\BankRecHistory.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'BankTransaction';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\BankTransaction.csv'
FORMAT ASCII QUOTE '"';
select * from dba.BankTransaction;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\BankTransaction.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'BillHeader';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\BillHeader.csv'
FORMAT ASCII QUOTE '"';
select * from dba.BillHeader;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\BillHeader.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'BillingCycles';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\BillingCycles.csv'
FORMAT ASCII QUOTE '"';
select * from dba.BillingCycles;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\BillingCycles.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'BillLineItem';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\BillLineItem.csv'
FORMAT ASCII QUOTE '"';
select * from dba.BillLineItem;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\BillLineItem.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Budget';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Budget.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Budget;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Budget.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'BudgetAdjustment';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\BudgetAdjustment.csv'
FORMAT ASCII QUOTE '"';
select * from dba.BudgetAdjustment;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\BudgetAdjustment.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CallNumber';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallNumber.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CallNumber;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallNumber.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CallOrder';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallOrder.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CallOrder;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallOrder.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CallsTable';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallsTable.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CallsTable;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallsTable.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CallTypes';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallTypes.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CallTypes;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CallTypes.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CashFlowTable';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CashFlowTable.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CashFlowTable;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CashFlowTable.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CCRecHistory';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CCRecHistory.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CCRecHistory;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CCRecHistory.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Central';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Central.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Central;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Central.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CentralRemote';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CentralRemote.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CentralRemote;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CentralRemote.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CentralStation';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CentralStation.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CentralStation;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CentralStation.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CentralTrouble';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CentralTrouble.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CentralTrouble;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CentralTrouble.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ChartOfAccounts';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ChartOfAccounts.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ChartOfAccounts;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ChartOfAccounts.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CollectDealerBilling';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CollectDealerBilling.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CollectDealerBilling;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CollectDealerBilling.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CommissionApproval';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CommissionApproval.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CommissionApproval;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CommissionApproval.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CommissionsAdjustments';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CommissionsAdjustments.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CommissionsAdjustments;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CommissionsAdjustments.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CommunicatorFormat';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CommunicatorFormat.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CommunicatorFormat;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CommunicatorFormat.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Company';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Company.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Company;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Company.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CompanySettings';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CompanySettings.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CompanySettings;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CompanySettings.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ConditionCodeResolutions';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ConditionCodeResolutions.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ConditionCodeResolutions;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ConditionCodeResolutions.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ConditionsContactLists';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ConditionsContactLists.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ConditionsContactLists;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ConditionsContactLists.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Contract';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Contract.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Contract;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Contract.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ContractType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ContractType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ContractType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ContractType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ConvertedProspects';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ConvertedProspects.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ConvertedProspects;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ConvertedProspects.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CreditCardReconciliation';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CreditCardReconciliation.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CreditCardReconciliation;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CreditCardReconciliation.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CreditCardRegister';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CreditCardRegister.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CreditCardRegister;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CreditCardRegister.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CreditMemoAllocation';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CreditMemoAllocation.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CreditMemoAllocation;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CreditMemoAllocation.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CSCounter';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSCounter.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CSCounter;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSCounter.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CSIDGenerator';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDGenerator.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CSIDGenerator;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDGenerator.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CSIDRestoralInfo';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDRestoralInfo.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CSIDRestoralInfo;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDRestoralInfo.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CSIDZone';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDZone.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CSIDZone;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDZone.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CSIDZoneGraphic';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDZoneGraphic.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CSIDZoneGraphic;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CSIDZoneGraphic.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactContact';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactContact.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactContact;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactContact.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactMail';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactMail.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactMail;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactMail.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactMailType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactMailType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactMailType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactMailType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactPhone';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactPhone.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactPhone;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactPhone.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactPhoneType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactPhoneType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactPhoneType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactPhoneType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactRelation';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactRelation.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactRelation;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactRelation.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CtactRelationType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactRelationType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CtactRelationType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CtactRelationType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CusCon_History';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_History.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CusCon_History;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_History.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CusCon_HistoryDetail';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_HistoryDetail.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CusCon_HistoryDetail;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_HistoryDetail.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CusCon_IgnoreEmails';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_IgnoreEmails.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CusCon_IgnoreEmails;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_IgnoreEmails.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CusCon_Schedule';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_Schedule.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CusCon_Schedule;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CusCon_Schedule.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CustomerHIstory';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CustomerHIstory.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CustomerHIstory;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CustomerHIstory.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'CustomReports';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\CustomReports.csv'
FORMAT ASCII QUOTE '"';
select * from dba.CustomReports;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\CustomReports.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DayLightSavingsRules';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DayLightSavingsRules.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DayLightSavingsRules;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DayLightSavingsRules.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Dealer';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Dealer.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Dealer;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Dealer.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DealerBillingSummary';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerBillingSummary.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DealerBillingSummary;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerBillingSummary.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DealerPendingBilling';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerPendingBilling.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DealerPendingBilling;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerPendingBilling.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DealerPricing';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerPricing.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DealerPricing;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerPricing.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DealerTechnician';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerTechnician.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DealerTechnician;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerTechnician.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DealerUser';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerUser.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DealerUser;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerUser.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DealerUserConnection';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerUserConnection.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DealerUserConnection;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DealerUserConnection.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedAppointments';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedAppointments.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedAppointments;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedAppointments.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedBankTransaction';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBankTransaction.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedBankTransaction;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBankTransaction.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedBankTransaction';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBankTransaction.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedBankTransaction;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBankTransaction.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedBillHeader';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBillHeader.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedBillHeader;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBillHeader.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedBillLineItem';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBillLineItem.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedBillLineItem;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedBillLineItem.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedCallsTable';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedCallsTable.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedCallsTable;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedCallsTable.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedInvoiceHeader';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceHeader.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedInvoiceHeader;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceHeader.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedInvoiceHeader2';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceHeader2.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedInvoiceHeader2;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceHeader2.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedInvoiceLineItem';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceLineItem.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedInvoiceLineItem;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceLineItem.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedInvoiceLineItem2';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceLineItem2.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedInvoiceLineItem2;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedInvoiceLineItem2.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedJobs';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedJobs.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedJobs;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedJobs.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedJobTime';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedJobTime.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedJobTime;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedJobTime.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedPayment';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPayment.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedPayment;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPayment.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedPaymentAllocation';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPaymentAllocation.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedPaymentAllocation;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPaymentAllocation.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedPO';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPO.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedPO;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPO.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedPOLineItem';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPOLineItem.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedPOLineItem;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedPOLineItem.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedProposalHeader';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalHeader.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedProposalHeader;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalHeader.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedProposalLineItem';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalLineItem.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedProposalLineItem;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalLineItem.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedProposalOptions';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalOptions.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedProposalOptions;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalOptions.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedProposalRecurring';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalRecurring.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedProposalRecurring;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalRecurring.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedProposalWorkOrder';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalWorkOrder.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedProposalWorkOrder;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedProposalWorkOrder.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedReceipt';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedReceipt.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedReceipt;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedReceipt.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedReceiptAllocation';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedReceiptAllocation.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedReceiptAllocation;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedReceiptAllocation.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedRefunds';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedRefunds.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedRefunds;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedRefunds.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedWorkOrder';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedWorkOrder.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedWorkOrder;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedWorkOrder.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedWorkOrderDetail';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedWorkOrderDetail.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedWorkOrderDetail;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedWorkOrderDetail.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DeletedWorkOrderMaterialDetail';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedWorkOrderMaterialDetail.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DeletedWorkOrderMaterialDetail;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DeletedWorkOrderMaterialDetail.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Department';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Department.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Department;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Department.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DivisionGroup';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DivisionGroup.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DivisionGroup;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DivisionGroup.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'DivisionReportingGroup';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\DivisionReportingGroup.csv'
FORMAT ASCII QUOTE '"';
select * from dba.DivisionReportingGroup;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\DivisionReportingGroup.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Divisions';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Divisions.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Divisions;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Divisions.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Documents';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Documents.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Documents;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Documents.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EContracts';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EContracts.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EContracts;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EContracts.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmergencyManagementMode';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmergencyManagementMode.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmergencyManagementMode;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmergencyManagementMode.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Employee';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Employee.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Employee;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Employee.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeAlarmGroups';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeAlarmGroups.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeAlarmGroups;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeAlarmGroups.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeGroup';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeGroup.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeGroup;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeGroup.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeGroupAccess';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeGroupAccess.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeGroupAccess;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeGroupAccess.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeRates';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeRates.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeRates;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeRates.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeSkillList';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeSkillList.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeSkillList;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeSkillList.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeSkills';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeSkills.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeSkills;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeSkills.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EmployeeTrace';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeTrace.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EmployeeTrace;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EmployeeTrace.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EntityDefault';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EntityDefault.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EntityDefault;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EntityDefault.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EpAccountTransactionType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpAccountTransactionType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EpAccountTransactionType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpAccountTransactionType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EpPayBatch';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpPayBatch.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EpPayBatch;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpPayBatch.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EpPayBatchDet';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpPayBatchDet.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EpPayBatchDet;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpPayBatchDet.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EpPayBatchDetInvoice';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpPayBatchDetInvoice.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EpPayBatchDetInvoice;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpPayBatchDetInvoice.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EpSurcharge';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpSurcharge.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EpSurcharge;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpSurcharge.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EpTransactionCode';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpTransactionCode.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EpTransactionCode;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EpTransactionCode.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Equipment';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Equipment.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Equipment;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Equipment.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Event';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Event.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Event;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Event.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EventStack';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EventStack.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EventStack;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EventStack.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'EventStackHistory';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\EventStackHistory.csv'
FORMAT ASCII QUOTE '"';
select * from dba.EventStackHistory;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\EventStackHistory.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ExcessiveSignalProc';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ExcessiveSignalProc.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ExcessiveSignalProc;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ExcessiveSignalProc.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ExternalServicesConfiguration';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ExternalServicesConfiguration.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ExternalServicesConfiguration;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ExternalServicesConfiguration.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ExtServices';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ExtServices.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ExtServices;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ExtServices.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'FailedInvoiceItems';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\FailedInvoiceItems.csv'
FORMAT ASCII QUOTE '"';
select * from dba.FailedInvoiceItems;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\FailedInvoiceItems.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'FailedServices';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\FailedServices.csv'
FORMAT ASCII QUOTE '"';
select * from dba.FailedServices;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\FailedServices.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'FalseAlarms';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\FalseAlarms.csv'
FORMAT ASCII QUOTE '"';
select * from dba.FalseAlarms;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\FalseAlarms.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Favorities';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Favorities.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Favorities;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Favorities.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'FileType';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\FileType.csv'
FORMAT ASCII QUOTE '"';
select * from dba.FileType;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\FileType.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Filters';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Filters.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Filters;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Filters.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'FinancialSpreadSheets';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\FinancialSpreadSheets.csv'
FORMAT ASCII QUOTE '"';
select * from dba.FinancialSpreadSheets;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\FinancialSpreadSheets.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'Form';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\Form.csv'
FORMAT ASCII QUOTE '"';
select * from dba.Form;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\Form.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GatewayKind';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GatewayKind.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GatewayKind;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GatewayKind.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GeneralJournal';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GeneralJournal.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GeneralJournal;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GeneralJournal.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GJ';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GJ.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GJ;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GJ.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GJTEMPLATEHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GJTEMPLATEHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GJTEMPLATEHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GJTEMPLATEHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GJTEMPLATEITEMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GJTEMPLATEITEMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GJTEMPLATEITEMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GJTEMPLATEITEMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLACCOUNT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLACCOUNT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLACCOUNT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLACCOUNT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLBALANCES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLBALANCES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLBALANCES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLBALANCES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLCHECKPOINTHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLCHECKPOINTHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLCHECKPOINTHEADER1';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTHEADER1.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLCHECKPOINTHEADER1;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTHEADER1.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLCHECKPOINTITEMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTITEMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLCHECKPOINTITEMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTITEMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLCHECKPOINTITEMS1';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTITEMS1.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLCHECKPOINTITEMS1;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCHECKPOINTITEMS1.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLCOATEMP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCOATEMP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLCOATEMP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLCOATEMP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLMONTHLYSUMMARY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLMONTHLYSUMMARY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLMONTHLYSUMMARY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLMONTHLYSUMMARY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLNOTIFICATION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLNOTIFICATION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLNOTIFICATION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLNOTIFICATION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLPERIODS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLPERIODS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLPERIODS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLPERIODS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLRECONCILED';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLRECONCILED.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLRECONCILED;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLRECONCILED.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLUNRECONCILED';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLUNRECONCILED.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLUNRECONCILED;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLUNRECONCILED.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'GLUNRECONCILEDTRANSACTIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLUNRECONCILEDTRANSACTIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.GLUNRECONCILEDTRANSACTIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\GLUNRECONCILEDTRANSACTIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDACCESSGROUPDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDACCESSGROUPDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDACCESSGROUPDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDACCESSGROUPDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDACCESSGROUPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDACCESSGROUPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDACCESSGROUPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDACCESSGROUPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDCARDFORMATS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDCARDFORMATS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDCARDFORMATS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDCARDFORMATS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDCARDSET';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDCARDSET.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDCARDSET;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDCARDSET.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDCLASSCODES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDCLASSCODES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDCLASSCODES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDCLASSCODES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDDEFAULTCONFIGLIST';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDEFAULTCONFIGLIST.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDDEFAULTCONFIGLIST;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDEFAULTCONFIGLIST.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDDEFAULTSTARTSCRIPT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDEFAULTSTARTSCRIPT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDDEFAULTSTARTSCRIPT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDEFAULTSTARTSCRIPT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDDEFAULTTASKLIST';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDEFAULTTASKLIST.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDDEFAULTTASKLIST;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDEFAULTTASKLIST.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDDOORGROUPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDOORGROUPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDDOORGROUPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDOORGROUPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDDOORGROUPSDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDOORGROUPSDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDDOORGROUPSDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDDOORGROUPSDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDELEVATOR';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDELEVATOR.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDELEVATOR;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDELEVATOR.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDELEVATORGROUPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDELEVATORGROUPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDELEVATORGROUPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDELEVATORGROUPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDEVENTHISTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDEVENTHISTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDEVENTHISTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDEVENTHISTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDEVENTMESSAGES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDEVENTMESSAGES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDEVENTMESSAGES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDEVENTMESSAGES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDEXTENSIONMODULES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDEXTENSIONMODULES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDEXTENSIONMODULES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDEXTENSIONMODULES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDFIRMWAREVERSION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDFIRMWAREVERSION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDFIRMWAREVERSION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDFIRMWAREVERSION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDHOLIDAYS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDHOLIDAYS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDHOLIDAYS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDHOLIDAYS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDHOLIDAYSYSTEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDHOLIDAYSYSTEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDHOLIDAYSYSTEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDHOLIDAYSYSTEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDHOLIDAYSYSTEMDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDHOLIDAYSYSTEMDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDHOLIDAYSYSTEMDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDHOLIDAYSYSTEMDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDINPUTS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDINPUTS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDINPUTS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDINPUTS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDIOLINKER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDIOLINKER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDIOLINKER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDIOLINKER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDIOLINKERDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDIOLINKERDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDIOLINKERDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDIOLINKERDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDKEYPADS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDKEYPADS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDKEYPADS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDKEYPADS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDLOGICALINPUT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDLOGICALINPUT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDLOGICALINPUT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDLOGICALINPUT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDOUTPUTGROUPDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDOUTPUTGROUPDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDOUTPUTGROUPDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDOUTPUTGROUPDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDOUTPUTGROUPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDOUTPUTGROUPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDOUTPUTGROUPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDOUTPUTGROUPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDOUTPUTS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDOUTPUTS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDOUTPUTS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDOUTPUTS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDREADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDREADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDREADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDREADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDSAVEDOUTPUT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSAVEDOUTPUT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDSAVEDOUTPUT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSAVEDOUTPUT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDSCHEDULEDETAILS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSCHEDULEDETAILS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDSCHEDULEDETAILS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSCHEDULEDETAILS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDSCHEDULES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSCHEDULES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDSCHEDULES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSCHEDULES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDSYSTEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSYSTEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDSYSTEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSYSTEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDSYSTEMEXTENSION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSYSTEMEXTENSION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDSYSTEMEXTENSION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDSYSTEMEXTENSION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDTASKCODES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDTASKCODES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDTASKCODES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDTASKCODES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HIDWATCHDOG';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDWATCHDOG.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HIDWATCHDOG;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HIDWATCHDOG.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'HOLIDAYS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\HOLIDAYS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.HOLIDAYS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\HOLIDAYS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IDENTITYTHEFT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IDENTITYTHEFT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IDENTITYTHEFT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IDENTITYTHEFT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IF600';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IF600.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IF600;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IF600.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IF600_CODES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IF600_CODES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IF600_CODES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IF600_CODES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IGNOREONSEARCH';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IGNOREONSEARCH.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IGNOREONSEARCH;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IGNOREONSEARCH.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IMPFILEIMPORTMAPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPFILEIMPORTMAPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IMPFILEIMPORTMAPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPFILEIMPORTMAPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IMPFILEIMPORTTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPFILEIMPORTTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IMPFILEIMPORTTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPFILEIMPORTTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IMPIMPORTKIND';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPIMPORTKIND.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IMPIMPORTKIND;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPIMPORTKIND.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IMPSUBMAP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPSUBMAP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IMPSUBMAP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPSUBMAP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'IMPVENDORMAP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPVENDORMAP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.IMPVENDORMAP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\IMPVENDORMAP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INITIALIZEGLBALANCE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INITIALIZEGLBALANCE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INITIALIZEGLBALANCE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INITIALIZEGLBALANCE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INPROCESSING';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INPROCESSING.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INPROCESSING;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INPROCESSING.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INSURANCE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INSURANCE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INSURANCE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INSURANCE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVENTORYKITS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYKITS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVENTORYKITS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYKITS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVENTORYQUEUE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYQUEUE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVENTORYQUEUE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYQUEUE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVENTORYTRANSFER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYTRANSFER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVENTORYTRANSFER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYTRANSFER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVENTORYUSAGE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYUSAGE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVENTORYUSAGE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVENTORYUSAGE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVLINETEMP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVLINETEMP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVLINETEMP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVLINETEMP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVOICEHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICEHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVOICEHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICEHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVOICELINEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICELINEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVOICELINEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICELINEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVOICEORPHANS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICEORPHANS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVOICEORPHANS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICEORPHANS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'INVOICINGGROUPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICINGGROUPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.INVOICINGGROUPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\INVOICINGGROUPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBCOMMISSIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBCOMMISSIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBCOMMISSIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBCOMMISSIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBEXPENSE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBEXPENSE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBEXPENSE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBEXPENSE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBINVENTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBINVENTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBINVENTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBINVENTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBINVOICESCHEDULE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBINVOICESCHEDULE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBINVOICESCHEDULE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBINVOICESCHEDULE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBLINEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBLINEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBLINEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBLINEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBMATERIALS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBMATERIALS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBMATERIALS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBMATERIALS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBTASKS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTASKS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBTASKS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTASKS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBTASKTEMPLATE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTASKTEMPLATE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBTASKTEMPLATE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTASKTEMPLATE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBTASKTEMPLATEITEMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTASKTEMPLATEITEMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBTASKTEMPLATEITEMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTASKTEMPLATEITEMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBTIME';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTIME.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBTIME;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTIME.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'JOBTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.JOBTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\JOBTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LATEFEEGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LATEFEEGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LATEFEEGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LATEFEEGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LATEFEESUMMARY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LATEFEESUMMARY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LATEFEESUMMARY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LATEFEESUMMARY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LEADSOURCE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LEADSOURCE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LEADSOURCE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LEADSOURCE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LEADTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LEADTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LEADTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LEADTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LISTENIN';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LISTENIN.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LISTENIN;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LISTENIN.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LOG_RECURRINGREVENUE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LOG_RECURRINGREVENUE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LOG_RECURRINGREVENUE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LOG_RECURRINGREVENUE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'LOGGER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\LOGGER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.LOGGER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\LOGGER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MAMAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MAMAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MAMAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MAMAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MANOTIFICATION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MANOTIFICATION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MANOTIFICATION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MANOTIFICATION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MARKETAREA';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MARKETAREA.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MARKETAREA;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MARKETAREA.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MARKUPGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MARKUPGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MARKUPGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MARKUPGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MARKUPOVERRIDE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MARKUPOVERRIDE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MARKUPOVERRIDE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MARKUPOVERRIDE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MASMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MASMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MASMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MASMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MEDICALINFO';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MEDICALINFO.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MEDICALINFO;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MEDICALINFO.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSPERMISSION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSPERMISSION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSPERMISSION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSPERMISSION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSPICTURE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSPICTURE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSPICTURE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSPICTURE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSROLE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSROLE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSROLE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSROLE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSROLEPERMISSION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSROLEPERMISSION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSROLEPERMISSION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSROLEPERMISSION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSSCRIPT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSSCRIPT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSSCRIPT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSSCRIPT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSUSER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSUSER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSUSER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSUSER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSUSERACCESS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSUSERACCESS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSUSERACCESS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSUSERACCESS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MKSUSERROLE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSUSERROLE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MKSUSERROLE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MKSUSERROLE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCCSIDZONEDISPATCH';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCCSIDZONEDISPATCH.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCCSIDZONEDISPATCH;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCCSIDZONEDISPATCH.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCCSIDZONEOCTARCODE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCCSIDZONEOCTARCODE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCCSIDZONEOCTARCODE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCCSIDZONEOCTARCODE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCFREQUENCY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCFREQUENCY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCFREQUENCY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCFREQUENCY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCOCEVENTTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCOCEVENTTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCOCEVENTTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCOCEVENTTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCREMOTESESSION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCREMOTESESSION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCREMOTESESSION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCREMOTESESSION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCSTATES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCSTATES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCSTATES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCSTATES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCSUPERVISIONOPT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCSUPERVISIONOPT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCSUPERVISIONOPT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCSUPERVISIONOPT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCTAXCODE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCTAXCODE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCTAXCODE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCTAXCODE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCTESTEVENTVALIDTEST';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCTESTEVENTVALIDTEST.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCTESTEVENTVALIDTEST;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCTESTEVENTVALIDTEST.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCTIMEZONE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCTIMEZONE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCTIMEZONE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCTIMEZONE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'MNCULGRADE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCULGRADE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.MNCULGRADE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\MNCULGRADE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'NEEDRESTORAL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\NEEDRESTORAL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.NEEDRESTORAL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\NEEDRESTORAL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'NOTIFICATIONSTACK';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\NOTIFICATIONSTACK.csv'
FORMAT ASCII QUOTE '"';
select * from dba.NOTIFICATIONSTACK;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\NOTIFICATIONSTACK.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ONTEST';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ONTEST.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ONTEST;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ONTEST.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'OPERATOREFFICIENCY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATOREFFICIENCY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.OPERATOREFFICIENCY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATOREFFICIENCY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'OPERATORSKILLS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATORSKILLS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.OPERATORSKILLS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATORSKILLS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'OPERATORSTAT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATORSTAT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.OPERATORSTAT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATORSTAT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'OPERATORSTATDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATORSTATDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.OPERATORSTATDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\OPERATORSTATDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PACKAGECYCLEFEES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PACKAGECYCLEFEES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PACKAGECYCLEFEES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PACKAGECYCLEFEES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAGERSERVICE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAGERSERVICE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAGERSERVICE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAGERSERVICE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PANELCONNECTION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELCONNECTION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PANELCONNECTION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELCONNECTION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PANELTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PANELTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PANELZONE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELZONE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PANELZONE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELZONE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PANELZONERESTORALINFO';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELZONERESTORALINFO.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PANELZONERESTORALINFO;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PANELZONERESTORALINFO.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PARTS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PARTS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PARTS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PARTS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAYABLEAUDIT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYABLEAUDIT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAYABLEAUDIT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYABLEAUDIT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAYGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAYGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAYMENT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYMENT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAYMENT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYMENT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAYMENTALLOCATION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYMENTALLOCATION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAYMENTALLOCATION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYMENTALLOCATION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAYMENTGaTeWAYS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYMENTGaTeWAYS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAYMENTGaTeWAYS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYMENTGaTeWAYS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PAYROLLIMPORT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYROLLIMPORT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PAYROLLIMPORT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PAYROLLIMPORT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PBXCALL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PBXCALL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PBXCALL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PBXCALL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PBXEXT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PBXEXT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PBXEXT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PBXEXT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PEOPLETOCALL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PEOPLETOCALL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PEOPLETOCALL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PEOPLETOCALL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PO';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PO.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PO;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PO.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'POLINEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\POLINEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.POLINEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\POLINEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'POLINEITEMRECEIVED';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\POLINEITEMRECEIVED.csv'
FORMAT ASCII QUOTE '"';
select * from dba.POLINEITEMRECEIVED;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\POLINEITEMRECEIVED.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'POLINEITEMsLESSTHEN1QUANTITY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\POLINEITEMsLESSTHEN1QUANTITY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.POLINEITEMsLESSTHEN1QUANTITY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\POLINEITEMsLESSTHEN1QUANTITY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'POSTDEFERREDREVENUESUMMARY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\POSTDEFERREDREVENUESUMMARY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.POSTDEFERREDREVENUESUMMARY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\POSTDEFERREDREVENUESUMMARY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PPPAYMETHOD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PPPAYMETHOD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PPPAYMETHOD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PPPAYMETHOD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PPPAYMETHODTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PPPAYMETHODTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PPPAYMETHODTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PPPAYMETHODTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PREDEFINEDMESSAGES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PREDEFINEDMESSAGES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PREDEFINEDMESSAGES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PREDEFINEDMESSAGES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROJECTS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROJECTS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROJECTS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROJECTS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROJECTTEMPLATE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROJECTTEMPLATE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROJECTTEMPLATE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROJECTTEMPLATE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROJECTTEMPLATETASKS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROJECTTEMPLATETASKS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROJECTTEMPLATETASKS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROJECTTEMPLATETASKS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALLINEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALLINEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALLINEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALLINEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALLOSTREASON';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALLOSTREASON.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALLOSTREASON;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALLOSTREASON.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALOPTIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALOPTIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALOPTIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALOPTIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALPACKAGE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALPACKAGE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALPACKAGE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALPACKAGE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALPACKAGEITEMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALPACKAGEITEMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALPACKAGEITEMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALPACKAGEITEMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALPARAGRAPH';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALPARAGRAPH.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALPARAGRAPH;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALPARAGRAPH.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALRATINGPERIOD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALRATINGPERIOD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALRATINGPERIOD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALRATINGPERIOD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALRECURRING';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALRECURRING.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALRECURRING;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALRECURRING.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPoSALSTATUS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPoSALSTATUS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPoSALSTATUS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPoSALSTATUS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPoSALSTATUSPERIOD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPoSALSTATUSPERIOD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPoSALSTATUSPERIOD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPoSALSTATUSPERIOD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALSTATUSRATINGMOD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALSTATUSRATINGMOD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALSTATUSRATINGMOD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALSTATUSRATINGMOD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSALWORKORDER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALWORKORDER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSALWORKORDER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSALWORKORDER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROPOSedJOBINVENTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSedJOBINVENTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROPOSedJOBINVENTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROPOSedJOBINVENTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROSPECT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROSPECT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROSPECT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROSPECT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROSPECTADDRESS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROSPECTADDRESS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROSPECTADDRESS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROSPECTADDRESS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'PROSPECTSTATUS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROSPECTSTATUS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.PROSPECTSTATUS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\PROSPECTSTATUS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'QUICK_DE_TEMPLATE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\QUICK_DE_TEMPLATE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.QUICK_DE_TEMPLATE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\QUICK_DE_TEMPLATE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'QUICK_DE_TEMPLATE_DETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\QUICK_DE_TEMPLATE_DETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.QUICK_DE_TEMPLATE_DETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\QUICK_DE_TEMPLATE_DETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'QUICKNOTE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\QUICKNOTE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.QUICKNOTE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\QUICKNOTE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIPT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIPT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIPTALLOCATION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTALLOCATION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIPTALLOCATION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTALLOCATION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIPTALLOCATIONDELETED';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTALLOCATIONDELETED.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIPTALLOCATIONDELETED;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTALLOCATIONDELETED.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIPTQUEUE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTQUEUE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIPTQUEUE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTQUEUE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIPTTEMP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTTEMP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIPTTEMP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIPTTEMP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIVABLEAUDIT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVABLEAUDIT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIVABLEAUDIT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVABLEAUDIT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIVER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIVER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIVERGROUPHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERGROUPHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIVERGROUPHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERGROUPHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIVERGROUPLINEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERGROUPLINEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIVERGROUPLINEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERGROUPLINEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIVERIPPORT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERIPPORT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIVERIPPORT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERIPPORT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECEIVERPORT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERPORT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECEIVERPORT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECEIVERPORT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECONCILETABLE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECONCILETABLE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECONCILETABLE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECONCILETABLE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECONCILETABLESUMMARY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECONCILETABLESUMMARY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECONCILETABLESUMMARY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECONCILETABLESUMMARY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECORDEDCALLS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECORDEDCALLS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECORDEDCALLS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECORDEDCALLS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECORDLOCKS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECORDLOCKS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECORDLOCKS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECORDLOCKS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECURRINGPURCHASE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECURRINGPURCHASE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECURRINGPURCHASE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECURRINGPURCHASE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RECURRINGREVENUE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECURRINGREVENUE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RECURRINGREVENUE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RECURRINGREVENUE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REFUNDS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REFUNDS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REFUNDS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REFUNDS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REFUNDTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REFUNDTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REFUNDTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REFUNDTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RELAYCARDS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RELAYCARDS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RELAYCARDS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RELAYCARDS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REMINDERHISTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REMINDERHISTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REMINDERHISTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REMINDERHISTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REMINDERS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REMINDERS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REMINDERS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REMINDERS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REMINDERTYPES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REMINDERTYPES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REMINDERTYPES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REMINDERTYPES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REPORTFOLDER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTFOLDER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REPORTFOLDER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTFOLDER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REPORTITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REPORTITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REPORTS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REPORTS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'REPORTSCONFIG';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTSCONFIG.csv'
FORMAT ASCII QUOTE '"';
select * from dba.REPORTSCONFIG;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\REPORTSCONFIG.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RESERVEDINVENTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESERVEDINVENTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RESERVEDINVENTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESERVEDINVENTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RESOLUTION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESOLUTION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RESOLUTION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESOLUTION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RESOLUTIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESOLUTIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RESOLUTIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESOLUTIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RESOURCES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESOURCES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RESOURCES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RESOURCES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RMRRATECHANGE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RMRRATECHANGE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RMRRATECHANGE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RMRRATECHANGE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'RRBILLINGHISTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\RRBILLINGHISTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.RRBILLINGHISTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\RRBILLINGHISTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SALEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SALEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SALEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SALEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SALEITEMGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SALEITEMGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SALEITEMGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SALEITEMGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SALESTEAMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SALESTEAMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SALESTEAMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SALESTEAMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SAVEDCCRECONCILEPARAMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SAVEDCCRECONCILEPARAMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SAVEDCCRECONCILEPARAMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SAVEDCCRECONCILEPARAMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SAVEDRECONCILEPARAMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SAVEDRECONCILEPARAMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SAVEDRECONCILEPARAMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SAVEDRECONCILEPARAMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SCREENLAYOUT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SCREENLAYOUT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SCREENLAYOUT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SCREENLAYOUT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SECURITYCOMPANY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SECURITYCOMPANY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SECURITYCOMPANY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SECURITYCOMPANY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SERVICE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SERVICE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SERVICECONTRACT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICECONTRACT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SERVICECONTRACT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICECONTRACT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SERVICETYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICETYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SERVICETYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICETYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SERVICETYPESKILLS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICETYPESKILLS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SERVICETYPESKILLS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SERVICETYPESKILLS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SHIPPINGMETHOD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SHIPPINGMETHOD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SHIPPINGMETHOD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SHIPPINGMETHOD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SIACODE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SIACODE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SIACODE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SIACODE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'STACKDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\STACKDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.STACKDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\STACKDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBCONTRACTS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBCONTRACTS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBCONTRACTS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBCONTRACTS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBDEALER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBDEALER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBDEALER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBDEALER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SubscriberListing';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERListing.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SubscriberListing;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERListing.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERACCESS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERACCESS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERACCESS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERACCESS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERACTIONPLANS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERACTIONPLANS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERACTIONPLANS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERACTIONPLANS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERADDRESS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERADDRESS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERADDRESS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERADDRESS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERCUSTOMFLD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERCUSTOMFLD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERCUSTOMFLD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERCUSTOMFLD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERHOLIDAYS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERHOLIDAYS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERHOLIDAYS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERHOLIDAYS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERPANEL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERPANEL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERPANEL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERPANEL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSCRIBERWORKORDERFLD';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERWORKORDERFLD.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSCRIBERWORKORDERFLD;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSCRIBERWORKORDERFLD.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUBSERVICETYPES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSERVICETYPES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUBSERVICETYPES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUBSERVICETYPES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUMMARY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUMMARY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUMMARY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUMMARY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SURVEY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SURVEY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SURVEY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SURVEY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SUSPENDEDINVOICING';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUSPENDEDINVOICING.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SUSPENDEDINVOICING;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SUSPENDEDINVOICING.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SYSLOG';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SYSLOG.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SYSLOG;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SYSLOG.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'SYSTEMAUDIT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\SYSTEMAUDIT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.SYSTEMAUDIT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\SYSTEMAUDIT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TAGLINK';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAGLINK.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TAGLINK;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAGLINK.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TASKS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TASKS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TASKS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TASKS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TASKTYPE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TASKTYPE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TASKTYPE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TASKTYPE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TAXRATE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAXRATE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TAXRATE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAXRATE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TAXRATEITEMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAXRATEITEMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TAXRATEITEMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAXRATEITEMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TAXRATEMULTINATIONAL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAXRATEMULTINATIONAL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TAXRATEMULTINATIONAL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TAXRATEMULTINATIONAL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TECHCOVERAGEAREAS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHCOVERAGEAREAS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TECHCOVERAGEAREAS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHCOVERAGEAREAS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TECHNICianGROUPDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHNICianGROUPDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TECHNICianGROUPDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHNICianGROUPDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TECHnicianGROUPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHnicianGROUPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TECHnicianGROUPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHnicianGROUPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TECHSTATUS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHSTATUS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TECHSTATUS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TECHSTATUS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TEMPBUDGET';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPBUDGET.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TEMPBUDGET;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPBUDGET.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TEMPDEALERPENDINGBILLING';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPDEALERPENDINGBILLING.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TEMPDEALERPENDINGBILLING;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPDEALERPENDINGBILLING.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TEMPINVOICEHEADER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPINVOICEHEADER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TEMPINVOICEHEADER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPINVOICEHEADER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TEMPINVOICELINEITEMS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPINVOICELINEITEMS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TEMPINVOICELINEITEMS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPINVOICELINEITEMS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TEMPLATES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPLATES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TEMPLATES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPLATES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TEMPNOTES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPNOTES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TEMPNOTES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TEMPNOTES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TESTRT';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TESTRT.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TESTRT;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TESTRT.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'THIRDPARTYCYCLEFEES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\THIRDPARTYCYCLEFEES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.THIRDPARTYCYCLEFEES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\THIRDPARTYCYCLEFEES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'THIRDPARTYINFORMATION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\THIRDPARTYINFORMATION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.THIRDPARTYINFORMATION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\THIRDPARTYINFORMATION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TIMEDSUBSCRIBERNOTES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TIMEDSUBSCRIBERNOTES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TIMEDSUBSCRIBERNOTES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TIMEDSUBSCRIBERNOTES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TMPSALEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TMPSALEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TMPSALEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TMPSALEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TOWNCODE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TOWNCODE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TOWNCODE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TOWNCODE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TRANSACTIONFILE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TRANSACTIONFILE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TRANSACTIONFILE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TRANSACTIONFILE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TRANSACTIONRESPONSE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TRANSACTIONRESPONSE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TRANSACTIONRESPONSE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TRANSACTIONRESPONSE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'TRANSFERREDBILLPAYER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\TRANSFERREDBILLPAYER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.TRANSFERREDBILLPAYER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\TRANSFERREDBILLPAYER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'UNIQUEPAYGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\UNIQUEPAYGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.UNIQUEPAYGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\UNIQUEPAYGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'UNLISTEDSURVEYS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\UNLISTEDSURVEYS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.UNLISTEDSURVEYS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\UNLISTEDSURVEYS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'USERACCESS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERACCESS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.USERACCESS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERACCESS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'USERGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.USERGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'USERLOGINS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERLOGINS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.USERLOGINS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERLOGINS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'USEROPTIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\USEROPTIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.USEROPTIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\USEROPTIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'USERSETTINGS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERSETTINGS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.USERSETTINGS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERSETTINGS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'USERWIDGETS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERWIDGETS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.USERWIDGETS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\USERWIDGETS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VEHICLE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VEHICLE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VEHICLE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VEHICLE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VENDOR';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDOR.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VENDOR;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDOR.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VENDORCLASSIFICATION';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDORCLASSIFICATION.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VENDORCLASSIFICATION;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDORCLASSIFICATION.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VENDORCODES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDORCODES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VENDORCODES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDORCODES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VENDORHISTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDORHISTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VENDORHISTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VENDORHISTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VERIFICATIONRESPONSE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VERIFICATIONRESPONSE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VERIFICATIONRESPONSE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VERIFICATIONRESPONSE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VIRTUALPHONELINE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VIRTUALPHONELINE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VIRTUALPHONELINE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VIRTUALPHONELINE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'VOOPTIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\VOOPTIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.VOOPTIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\VOOPTIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WAREHOUSE';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WAREHOUSE.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WAREHOUSE;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WAREHOUSE.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WAREHOUSEINVENTORY';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WAREHOUSEINVENTORY.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WAREHOUSEINVENTORY;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WAREHOUSEINVENTORY.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WEBVIEWMYUSER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WEBVIEWMYUSER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WEBVIEWMYUSER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WEBVIEWMYUSER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WEDGENOTIFICATIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WEDGENOTIFICATIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WEDGENOTIFICATIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WEDGENOTIFICATIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WHOLESALEGROUP';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WHOLESALEGROUP.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WHOLESALEGROUP;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WHOLESALEGROUP.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WORKORDER';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDER.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WORKORDER;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDER.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WORKORDERDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WORKORDERDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WORKORDERLINEITEM';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERLINEITEM.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WORKORDERLINEITEM;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERLINEITEM.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WORKORDERMATERIALDETAIL';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERMATERIALDETAIL.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WORKORDERMATERIALDETAIL;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERMATERIALDETAIL.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WORKORDERRESOLUTIONS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERRESOLUTIONS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WORKORDERRESOLUTIONS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERRESOLUTIONS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WORKORDERRESOURCES';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERRESOURCES.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WORKORDERRESOURCES;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WORKORDERRESOURCES.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'WOSPRIOR';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\WOSPRIOR.csv'
FORMAT ASCII QUOTE '"';
select * from dba.WOSPRIOR;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\WOSPRIOR.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ZPS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZPS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ZiPS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZPS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ZONECOMMANDS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZONECOMMANDS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ZONECOMMANDS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZONECOMMANDS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ZONEEQUiPDRIVERS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZONEEQUiPDRIVERS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ZONEEQUiPDRIVERS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZONEEQUiPDRIVERS.csv'
FORMAT ASCII QUOTE '"' APPEND;
select list(string('"', cname, '"') order by colno asc)
from sys.syscolumns where creator = 'dba' and tname = 'ZONETRIGGERSUBSCRIBERS';
OUTPUT to 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZONETRIGGERSUBSCRIBERS.csv'
FORMAT ASCII QUOTE '"';
select * from dba.ZONETRIGGERSUBSCRIBERS;
OUTPUT TO 'C:\Users\matthew.helm\Downloads\[CompanyName]\ZONETRIGGERSUBSCRIBERS.csv'
FORMAT ASCII QUOTE '"' APPEND;
