Trail Blazer Knowledge Base:


Home : MS SQL Server : SQL Server table views

Knowledge Base







User:

Password:



Article ID: KB13
Keyword Name:
Created: June 04, 2007
Viewed: 3922

SQL Server table views

Trail Blazer stores data with arbitrary table names of the form
TBnnnnnn and column names of the form CLnnnnnn (where nnnnnnn is a
number).  The short (8 characters) and unique (each column had a
unique name) nature of the naming convention provides some significant
advantages to the product, both in terms of performance and
programming.  However, when users wished to access Trail Blazer
with a third-party product, such as a report writer, you would need to
use these arbitrary names. 

Trail Blazer now provides a facility to generate for any Trail Blazer SQL
table an SQL view with meaningful column names.  The third-party
product can then refer to the SQL view rather than the underlying SQL
table.


Find our more information about Trail Blazer Campaign Services Inc. [click here]


Powered by: ClickCarts KnowledgeBase