Dropping a Foreign Key

Drop a foreign key to release column constraints determined by another table.

Prerequisites 

Before you can drop a foreign key, be sure that the data server containing the table for which you are creating a foreign key is running and you created and established a connection to the data server.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Expand the Tables folder and then expand the table that contains the foreign key you want to drop.
  3. Expand the Foreign Keys folder and find the foreign key you want to drop.
  4. Right-click the foreign key and choose Drop.
Related concepts
Foreign Keys
Related tasks
Creating a Foreign Key
Editing a Foreign Key

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