The
new database appears among any other databases that were already in existence,
as shown in Illustration 10.
Now
let's create a table to contain our Subscriber information.
14.
Expand the RS_Subscription database by clicking the "+"
sign to its immediate left, from the left pane in the Management Console,
as shown in Illustration 11.
15.
Right-click the
Tables node within the expanded database.
16.
Select New
Table ... from the context menu that appears, as depicted in Illustration
12.
Illustration 12: Select
New Table ...
The Table
Designer appears. Here we can easily create columns and other table
details.
17.
Add the
columns and details depicted in Table 1 to the appropriate places in the
Table Designer grid.
|
Column Name
|
Data Type
|
Length
|
Allow Nulls
|
Description
|
|
Participant
|
Varchar
|
50
|
Unchecked
|
Subscriber Name
|
|
File_Share
|
Varchar
|
165
|
Unchecked
|
File Share Qualified Name
|
|
Identification_No
|
Varchar
|
50
|
Unchecked
|
Associate ID Number
|
|
Media_Format
|
Varchar
|
50
|
Unchecked
|
Report File Type
|
|
Parameter
|
Varchar
|
50
|
Unchecked
|
Filter Parameter
|
Table 1: New
Table Construction Details
Once
the information in the table is entered, the Table Designer grid will
appear as shown in Illustration 13.
Illustration 13: The
Completed Table Designer Grid
18.
Click the Save
icon, depicted in Illustration 14, to name and save the new table.
Illustration 14: The
Save Icon
The Choose
Name dialog appears.
19.
Enter the
following as the table name:
SubscriberDetails
The Choose
Name dialog appears as shown in Illustration 15.
Illustration 15: The
Completed Choose Name Dialog
20.
Click OK.
21.
Close the Table
Designer grid by double-clicking the Enterprise Manager icon to the
left of the Save icon (circled in Illustration 16).
NOTE: Be sure to double-click the
correct icon - the one on the Table Designer bar, not the one on the Management
Console bar, as is noted in Illustration 16.
Illustration 16: Closing
Table Designer
Once Table
Designer closes, we see the new SubscriberDetails table, among the
system tables of the RS_Subscription database, as shown in Illustration 17.
Illustration 17: The
New Table Appears ...
» 
Comment and Contribute
