Creating a User Table

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.
  1. 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.
  2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables and select User Tables.
  3. Select New.
    You see the Add User Table wizard.
  4. In the Introduction window, select the server, database, and owner for the new table.
  5. Enter a name for the user table.
  6. Enter the SQL statements for the new table and related table objects.
  7. (Optional) Click Summary to verify your selected options.
  8. Click Finish to create the user table.
Parent topic: Manage Tables
Related tasks
Creating a Proxy Table