Teradata SQL

-SHOW TABLE | VIEW | MACRO | TRIGGER | PROCEDURE <target-name>;

Findout how table was created

-DATABASE <database-name>;

Change default database

-HELP DATABASE <database-name>;

Get database info

-SELECT * FROM <table-name> SAMPLE 20 | .50;

Get 20 sample | 50% sample