All Forums Training
11 May 2009
new to Teradata

Hello, I am new to useing Teradata. I have been useing MS SQL for over a year now. In MS SQL i am used to haveing a graphical interface to make the tables and drag and drop the foreign keys. I am haveing trouble linking tables in Teradata Adminstrator. Keeps telling me user does not have rights to create. (tried on the tdadmin and tduser). anyone point me in the right direction. Thanks

Adeel Chaudhry 773 posts Joined 04/08
12 May 2009

Hello,As life is not as simple as drag n drop .... so you will have to write the SQL yourself! :)The documentation "SQL Reference: Fundamentals" available at following link, contains a full chapter with a name "Referential Integrity". Go through it, it contains examples as well.Link: http://www.info.teradata.com/HTH!Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

12 May 2009

thank you, I'll check it out.

12 May 2009

While the PDF is helpful, it only goes into definitions. Is there anywhere i can see examples of code I.E. code to set up tables?

joedsilva 505 posts Joined 07/05
12 May 2009

In SQL Assistant, press F2

GDU 1 post Joined 07/09
27 Jul 2009

Hi.I m New to Teradata..I want to learn teradata course..Can any one provide good institutes in hyderabad for teradata.this will be helpful for me..In teradata how will be the career opportunities.??Can any one suggest please..thanks in advance.

You must sign in to leave a comment.