Creating a User or Proxy Table

Create a user or proxy table to store and provide access to user data.

A proxy table is a user table that allows you to access data in a remote table, view, remote procedure call, directory, or file. A proxy table has all the attributes of a user table, such as columns, indexes, and triggers, but it does not contain any data locally.

Note: Only a database owner or a user with create table permission can create a table.
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Select New.
  3. On the Introduction window, select the server, database, and owner for the new table.
  4. Enter a name for the table.
  5. Enter the SQL statements for the new table and related table objects.

    For example, this SQL statement creates a table called titles in the pubs2 database:

    create table titles 
    (title_id tid,  
    title varchar(80) not null,  
    type char(12),  
    pub_id char(4) null,  
    price money null, 
    advance money null, 
    royalty int null,  
    total_sales int null,  
    notes varchar(200) null, 
    pubdate datetime, 
    contract bit not null)  
  6. (Optional) Click Summary to review your selected options.
  7. Click Finish to create the table.