Adding tables to a database

Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the catproc.sql script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course.

20p trinh02 28-01-2013 63 4   Download

[ Team LiB ] Recipe 10.8 Adding Tables to a Database Problem You need to add a table to an existing database. Solution Use the CREATE TABLE statement. The sample code executes the DDL statement—using the ExecuteNonQuery( ) method of the Command object—to add a table to an existing SQL Server database.

3p luvpro 04-08-2010 98 6   Download

Adding Restrictions to DataTable and DataColumn Objects As you know, a DataSet object is used to store a copy of a subset of the database. For example, you can store a copy of the rows from database tables into a DataSet

5p daisuphu 29-07-2010 115 6   Download