Table Columns
SAP Sybase IQ stores data in columns. Add, modify, and delete table columns.
Adding a Column
Add a column to a base table or global temporary table.
Deleting a Column
Delete a column from the table. If the table has only one column, you cannot delete it.
Viewing or Modifying Column Properties
Display or change the properties of the columns of the selected table.
Table Column Privilege Summary
A list of the system privileges and object permissions required to complete the various table column tasks.
Parent topic:
Tables
Related concepts
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table with No Partitions in the IQ Main Store
Creating a Table with No Partitions in the IQ (Catalog) System Store
Creating a Table with a Hash Partition
Creating a Table with a Range Partition
Creating a Table with a Hash-Range Partition
Creating a Global Temporary Table
Creating a Proxy Table
Viewing Table Data in the Execute SQL Window
Deleting a Table
Generating Table DDL Commands
Moving a Table to Another Dbspace
Validating a System Store Table
Setting the Primary Key
Setting a Clustered Index
Merging Table Data from RLV Store with IQ Main Store
Calculating the Number of Rows in a Table
Moving Table Objects to Another Dbspace
Enabling or Disabling Row-Level Versioning in a Table
Viewing or Modifying Base Table Properties
Viewing or Modifying Global Temporary Table Properties
Viewing and Modifying Proxy Table Properties
Related reference
Table Privilege Summary
Created November 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com