Teradata Objects

Table:- Table is a two dimensional structure.It is having both rows and columns.

View:- View is a predefined set of one or more tables (or) views.

Macro:- Macro is predefind set one or more DML statements. It is Used for simplification of execution of frequently used DMLs .

Triggger:- Trigger it is a set of sql statements usually associated with table or columns of table and when column changes, the trigger fires effectively while executing the SQL statements.

Stored procedure:- Stored procedure means set of SQL statements invoked by using single SQL call.


No comments:

Post a Comment