Tuesday, July 31, 2012

SQL objects


SQL objects are

1) schemas,

2) data dictionaries, 

3) journals,

4) catalogs, 

5) tables, 

6) aliases, 

7) views, 

8) indexes, 

9) constraints, 

10) triggers, 

11) sequences, 

12) stored procedures, 

14) user-defined functions, 

15) user-defined types, 

16) and SQL packages. SQL creates and maintains these objects as system objects. 

A brief description of these objects follows: