Create a user table to store and provide access to user data.
Note: Only a database owner or a user with create table permission can create a table.
- In the Perspective Resources view, select the servers on which the table is to be created, then click the drop-down arrow next to a server name and select Administration Console.
- In the left pane of the Administration Console, expand and select User Tables.
- Select New.
You see the Add User Table wizard.
- In the Introduction window, select the server, database, and owner for the new table.
- Enter a name for the user table.
- Enter the SQL statements for the new table and related table objects.
- (Optional) Click Summary to verify your selected options.
- Click Finish to create the user table.