Toad World® Forums

How do you create a table alias in the database diagram?

I am new to Toad Data Point and I am creating a database diagram to use as a template for the query builder. How do you create a table alias in the database diagram? I have dimension tables like date_dim and race_dim that I would like to join multiple copies of to the fact tables using table aliases but I can’t figure out how to do that in the database diagram. Thank you for your help.

TDP does not support aliases in ER diagram but when you send a diagram to Query Builder you will be able to set aliases for tables.
To do so select columns you’d like to include into the query and then set the aliases in property grid. It’s the last row in the property grid.

Regards

Aleksey

We have been able to create aliases in Query Builder and that will work for us.

Thank you,

Katherine Benson

IS Administrator

Hawaii Health Data Warehouse

Ph: (855) 946-5899, x13 (toll free)

Visit: www.hhdw.org
or www.HawaiiHealthMatters.org

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]

Sent: Tuesday, March 21, 2017 2:02 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] How do you create a table alias in the database diagram?

RE: How do you create a table alias in the database diagram?

Reply by Aleksey Bazhenov

TDP does not support aliases in ER diagram but when you send a diagram to Query Builder you will be able to set aliases for tables.

To do so select columns you’d like to include into the query and then set the aliases in property grid. It’s the last row in the property grid.

Regards

Aleksey

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point Forum
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.