By definition, a database is a collection of objects and processes that manage these objects. Before you can start doing anything with a database, you (or somebody else) has to design it and then create its objects. The database design is a separate (though related to) SQL topic; we give a crash course in RDBMS design basics in Appendix C. This chapter is about creating objects in a relational database.
Cross-References |
To be able to create database objects you must have sufficient (implementation specific) security privileges. See Chapter 12 for detailed discussion of SQL security. |