[prev] 27 [next]

Catalogs (cont)

The catalog is affected by several types of SQL operations:
  • create Object as Definition
  • drop Object ...
  • alter Object   Changes
  • grant Privilege on Object
where Object is one of table, view, function, trigger, schema, ...

E.g. drop table Groups; produces something like 

delete from Tables
where  schema = 'public' and name = 'groups';