Page 229 - Open Soource Technologies 304.indd
P. 229
Unit 10: Database Fundamentals and Connectivity Option
Figure 10.2: Creating Data Base.
2. Fill in the necessary information (for details, see the online help), and click OK. We are
notified that the database has been created successfully.
10.3.2 Create a Table Using Visual DBA
After create a database, we can create its tables, indexes, and other database objects.
10.3.3 To Create a Base Table
1. Expand the Databases object category branch in the Database Object Manager window, and
then expand the branch of the database in which the table will be created.
2. Select the Tables object category branch and click the Add Object toolbar button .
The Create Table dialog appears.
3. Enter a unique, valid name for the table in the Table Name field. In the sample dialog
below, the airport table in the demodb database is being created.
We can create a table from another table by selecting the Create Table as
Select check box. For detailed information about each option, see the Visual
DBA online help.
4. Enter a column name in the Name edit control in the column layout box (for example,
ap_id) and click Add. A column is added to the column layout box.
LOVELY PROFESSIONAL UNIVERSITY 223
