SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'posts_user_id_foreign'; check that column/key exists
Created at 28-Jul-2021 ,
By samar
Error SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'posts_user_id_foreign'; check that column/key exists occurs when you try to delete the foreign key which does not already exist in your table.
-
Check constraints name 'posts_user_id_foreign' exists or not in SQL
SELECT `TABLE_SCHEMA`, `TABLE_NAME` FROM `information_schema`.`KEY_COLUMN_USAGE` WHERE `CONSTRAINT_NAME` IN ('posts_user_id_foreign')You can use the SQL query to check the CONSTRAINT_NAME 'posts_user_id_foreign' exists or not.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to customize pagination view in laravel
- How to use or operator in laravel
- How to start websocket server in laravel
- Store logged in user details in session and display in view in laravel
- Laravel get count with where condition
- Method Illuminate\Database\Eloquent\Collection::appends does not exist
- Pagination in laravel
- How to create event and listener in laravel ?
- How to get last month records in Laravel
- Laravel create default admin user
- Laravel 7 login error message not showing
- Validation errors for multiple forms on same page Laravel
- Return redirect laravel not working
- 419 page expired error in Laravel
- How to pass link from controller to view in laravel on ajax call
- How to get CSRF token in laravel controller
- SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table
- Link storage folder in laravel 8
- RuntimeException You must enable the openssl extension in your php.ini to load information from https://repo.packagist.org
- How to insert dynamic values to additional column with pivot column in pivot table on multiple records
- Display data in table using foreach in Laravel
- Get last week data in Laravel
- How to get specific columns using with method in laravel Eloquent relationship
- File_put_contents(/var/www/html/w3code/storage/framework/sessions/CXwN3EXKxERD6jgy3rADcaAAbAx8FRKih2JK7UO9): Failed to open stream: Permission denied
- How to check query string exists or not in laravel blade