Drop table with FKs

• river1

  SSC-Insane

  Points: 24309

  More actions

  June 26, 2015 at 3:51 am

  #309520

  Hi,

  When I drop a table should I also drop it's FK ? or they keys are removed with the table?

  Thank you.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 26, 2015 at 3:55 am

  #1808345

  Any constraints, triggers and indexes on a table are removed when you drop the table.

  John

• river1

  SSC-Insane

  Points: 24309

  More actions

  June 26, 2015 at 4:06 am

  #1808348

  thank you