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.
Parent topic: Tables