Copying a Column

Copy existing column DDL when editing table schema to rearrange columns for a table or to avoid having to re-create an existing column.

Prerequisites 

Before you can copy 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. In the Table Schema Editor, select the Columns tab for the table containing the column you want to copy.
  2. In the columns grid, right-click to the left of the Primary Key field for the table column you want to copy and choose Copy Row.

The DDL for the table column is copied and ready for pasting into this or another table in the the Table Schema Editor.

Related tasks
Creating a Column
Cutting a Column
Pasting 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