What are the commands to make a new table, change a table and remove a table in teradata?
- 1 Answers
- 1221 Views
- I also Faced
- E-Mail Answers
Answer / Km.upasna
"To create a new table, use the CREATE TABLE command. Here's an example:
CREATE TABLE table_name (column1 datatype, column2 datatype, ...);
To alter an existing table, use the ALTER TABLE command. For instance, to add a column:
ALTER TABLE table_name ADD COLUMN new_column datatype;
To delete a table, use the DROP TABLE command:
DROP TABLE table_name;"
| Is This Answer Correct ? | 0 Yes | 0 No |
What is collect State in Teradata ? what it use and how it works??
How a Referential integrity is handled in Teradata?
List out some of the primary characteristics of teradata.
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
What is the difference between fastload and multiload?
What are aggregate tables? How do you design them using teradata?
What is a three-tier data warehouse?
What do you mean by teradata intelliflex?
Fast Load Script is failed and error tables are available then how do you restart?
What are the primary characteristics of the Teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
In BTEQ, how are the session-mode parameters being set?
Teradata 
