codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Delete column with foreign key

    14th August 2018

    MySql

    mysql codehaven category

    If you have a stubborn phpmyadmin column that wont delete due to a foreign key then use this sql code below.

    1
    2
    3
    4
     
    ALTER TABLE `workers` DROP FOREIGN KEY `worker_fk0`;
    ALTER TABLE `workers` DROP COLUMN `skillsid`;
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN