Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Tables

 

Creating a table

You can use Sybase Central to create tables in your database.

Prérequis

You must have the CREATE TABLE system privilege to create tables owned by you. You must have the CREATE ANY TABLE or CREATE ANY OBJECT system privilege to create tables owned by others.

To create proxy tables owned by you, you must have the CREATE PROXY TABLE system privilege. You must have the CREATE ANY TABLE or CREATE ANY OBJECT system privilege to create proxy tables owned by others.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click Tables and click New » Table.

  3. Follow the instructions in the Create Table Wizard.

  4. In the right pane, click the Columns tab and create new columns for your table.

  5. Click File » Save.

Résultat

The new table is saved in the database.

Suivant

Enter or load data into your table.

 See also