How To E

how to list forign key of a table

How to List all Forign Keys of a SQL Table

List Forign keys of a table SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = ‘<database>’ AND REFERENCED_TABLE_NAME = ‘<table>’; List Forign keys of a table

Read More »

How To Install Docker on Ubuntu

Update the apt package index and install packages to allow apt to use a repository over HTTPS: sudo apt-get update   sudo apt-get install ca-certificates curl gnupg lsb-release   Add

Read More »
Scroll to top