script of teradata tables

Database
Highlighted
Enthusiast

script of teradata tables

Hi

may i know on which pdf i can find the table descriptions, there data about the tables used in the pdf. i.e CUSTOMER,OFFERINGS,ENROLLMENT, COURSES...etc. so that i can work on the examples provided in pdfs. do i need to run any script for that to create tables and to insert data into it.
3 REPLIES
Enthusiast

Re: script of teradata tables

Hi

like demobld.sql file of ORACLE is there any script available in Teradata. demobld.sql file contains all the tables like EMP,DEPT,JOBS,SALGRADE Tables structure and the rows for these tables. so i am expecting the same kind of script or a pdf which contains structure and its inserting rows or the name of teradata pdf which contains these information.

Senior Supporter

Re: script of teradata tables

Hi dixon,
there's a script in C:\Program Files\NCR\Tdat\LTDBMS\etc\perddl.bteq, but the sample db is quite small.
It's described in the manuals:
Basic Teradata Query Reference
APPENDIX B Loading and Using the Sample Personnel Database

Another option is to modify the Oracle script to Teradata-SQL. Then you could compare Teradata/Oracle SQL.
I did something similar once with Microsoft's pubs database.

Dieter
Teradata Employee

Re: script of teradata tables

Hi,


 


Where can I find the perddl.bteq in TD 13.10 Express Vmware?


 


Regards,


Joseph