Basic HTML version of Foils prepared 7 October 97

Foil 16 Data Definition Language statements (DDL)

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


Define, alter the structure of, and drop schema objects. More specifically:
  • create, alter, and drop schema objects and other database structures, including for DBA the database itself and database users (CREATE,ALTER,DROP)
  • change the names of schema objects (RENAME)
  • delete all the data in schema objects without removing the objects' structure (TRUNCATE)
  • gather statistics about schema objects, validate object structure, and list chained rows within objects (ANALYZE)
  • turn auditing options on and off (AUDIT,NOAUDIT)
  • add a comment to the data dictionary (COMMENT)
DDL implicitly commits the preceding transaction, and starts a new transaction



© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998