Drop foreign id column (user_id) in MySQL
You can drop the foreign id column user_id in MySQL. You have to first delete the foreign key and index before deleting the foreign id column else it will give error #1553 - Cannot drop index 'posts_user_id_foreign': needed in a foreign key constraint.
Answers 1
-
Drop column (foreign Id) user_id from posts table
ALTER TABLE `posts` DROP COLUMN `user_id`;0You can drop column user_id from posts table using drop column method in MySQL. If you are getting error #1553 Cannot drop index 'posts_user_id_foreign': needed in a foreign key constraint then you have to first delete the foreign key and indexes.
Random Code Snippet Queries: Sql
- Get data in random order with limit from table using mysql
- Create column after a column in existing table using query in MySQL
- Cannot drop index 'fk_role_id': needed in a foreign key constraint
- SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1
- How to check the MySQL version
- Change existing MySQL table column id to autoincrement
- Get create table Query from existing table in phpMyAdmin
- How to show database tables in mysql using command line
- SQL query to delete records older than 6 months
- SQL query to delete all rows older than 30 days
- Insert multiple rows in a single MySQL query
- How to check column exists or not in table using MySQL
- How to retrieve data from two tables with one SQL statement
- How to create a new table from existing table in SQL
- 1553 Cannot drop index 'posts_user_id_foreign': needed in a foreign key constraint
- Database connection using mySQLi with object-oriented
- Get comma separated ids from table using MySQL