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