This chapter describes essential tasks and best practices for working with tables and views: Choosing a primary index Creating tables or converting pre-existing tables from other vendors Copying, dropping, and recreating tables Creating views Using BTEQ scripts to create database objects