Knowledgebase
[QODBC-ALL] How to get information of Tables and Columns
Posted by Juliet on 04 November 2011 03:17 AM

How to get information of Tables and Columns

How to get information of Tables and Columns

There are totally more than 130 tables in QODBC, and there are several methods of viewing detailed information of QODBC tables as below.

Using Stored Procedures

There are some stored procedures in QODBC which will bring you a great convenience. You could refer to QODBC Stored Procedures Command List to get more information.

You could try to use a stored procedure called "sp_tables" and "sp_columns table_name" to get a detailed information of the available tables and columns. See: How to get the table schema rules as a reference.

Visit QODBC Website to Get the Data Layout of QODBC

You could also go to documentation site for more information on tables and fields. http://doc.qodbc.com/qodbc/Qodbc_20_us.html.

 

Tags: Table Field Types, Field Types, What does field type mean

(64 vote(s))
Helpful
Not helpful

Comments (2)
Don Lesser
03 December 2013 09:02 PM
Is the documentation for QuickBooks on the QODBC side the most up to date listing of fields? I need the most recent QuickBooks 2011 listing.
Jack
08 July 2014 10:20 AM
Hi Don,

Sorry, we don't have any documentation for listing of fields. but you can get all table's fields by running below command in VB Demo:

sp_columns TableName

For Example: sp_columns JournalEntryLine

The command will return the schema rules of selected table (In this example it is JournalEntryLine), including information about whether a column is updatable or insertable and relationship with other tables.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).