Pasting a Column

Paste copied column DDL when editing table schema to rearrange columns for a table or to avoid having to recreate an existing column.

Prerequisites 

Before you can paste a column, be sure that the data server containing the tables is running, and you created and established a connection to the data server. Open the table or tables in the Table Schema Editor. For example, to copy the DDL for a column in one table and paste the column into another table, open both the source and target tables.

  1. Copy the column you want to paste into a table.
  2. In the Table Schema Editor, select the Columns tab for the table into which you want to paste the copied column.
  3. In the columns grid, right-click to the left of the Primary Key field, and choose Paste.

The DDL for the table column is pasted at the end of the columns grid in the Table Schema Editor.

Related tasks
Creating a Column
Copying a Column
Cutting a Column
Dropping a Column
Entering Column Default Values

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com