Teradata ALTER TABLE ADD COLUMN statement adds a new column to an existing Teradata table without dropping it. Apart from adding a new column, the ADD function has the capabilities to add data types, size, whether or not the new … Read more »
Teradata DELETE TABLE statement removes all the records from a Teradata table. The DELETE TABLE statement will delete only records, the table structure will remain the same. Teradata DELETE TABLE Syntax The syntax for deleting all records: DELETE FROM database_name.tbl_name; … Read more »
In most of the popular RDBMS like SQL Server, Oracle, MySQL, etc we use truncate table statement to delete all the records from an existing table. The difference between the DELETE TABLE and the TRUNCATE TABLE is that here in … Read more »
The DROP TABLE statement removes an existing table along with data and table structure from the Teradata database. It removes the table structure from the data dictionary. As a result of the drop table, the table structure along with the … Read more »
The RENAME TABLE statement in Teradata renames an existing table in Teradata. In order to rename an existing table in Teradata, you must have DROP privileges on the table and CREATE TABLE privileges on its containing database or user. Teradata … Read more »
Creating a table in Teradata is almost similar to other Relational Databases. CREATE TABLE or CT is the command used to create a table in Teradata. CREATE TABLE Syntax: CREATE SET/MULTISET TABLE database_name.table_name, [NO] FALLBACK (column_name data_type attribute, … Read more »
The DELETE DATABASE statement in Teradata is used to delete all the database objects like data tables, views, macros, triggers, store procedures, user-defined functions from a database. To delete a database in Teradata you must have the DROP privileges on … Read more »
Teradata Drop Database statement is used to drop an empty database from the Teradata system. Before dropping a database in Teradata below point should be noted: The user you are using to drop a database should have the appropriate privileges … Read more »
Teradata CREATE DATABASE A Teradata database is a local repository for various kinds of database objects like Tables (requires perm space), Views (uses no perm space), Procedures (requires perm space), functions, etc. Teradata CREATE DATABASE syntax Below is the syntax … Read more »
Teradata FastExport Sample Script .LOGTABLE MYDB.STUDENT; /* define restart log */ .LOGON ip_address/username,password; /* DBC logon string*/ .BEGIN EXPORT SESSIONS 10; /* begin export with number of sessions to be used */ .EXPORT OUTFILE filepath/output.txt mode record format text; … Read more »