Create Tables For New Database. Once a database is created you can check it in the list of databases with the following SQL command. Its time to find out how to.
HERE CREATE TABLE is the one responsible for the creation of the table in the database. In Query Analyzer run the below Create SQL script to create our Tables. All columns or specific columns can be selected.
But the chances are most of your development will be against existing tables.
Enter a name such as ZACCOUNTS_XXX - always replacing XXX with your initials - and a description then choose Next. But making new tables is a small part of database development. Create a table in your package. If you create a new table using an existing table the new table will be filled with the existing values from the old table.
