Sql

Search

show constraints mysql

select COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_COLUMN_NAME, REFERENCED_TABLE_NAME
from information_schema.KEY_COLUMN_USAGE
where TABLE_NAME = 'yourTableName';

Comment

PREVIOUS	NEXT

Code Example
Sql :: create table in mysql
Sql :: get duplicate records in sql
Sql :: foreign key mysql
Sql :: how to get nearest location in mysql with latitude and longitude
Sql :: oracle sql date get month
Sql :: MYSQL select last query
Sql :: CONCAT_WS() concat function we can use for adds two or more expressions together with a separator or delimeter.
Sql :: SHOW COLUMNS Statement
Sql :: is between inclusive or exclusive sql
Sql :: SQL Auto Increment Primary Key - SQL Server
Sql :: date_part mysql
Sql :: add column if not exists mysql
Sql :: postgres set column equal to another
Sql :: t-sql merge example
Sql :: sqlite truncate tables command
Sql :: count column of tables psql
Sql :: How to convert DateTime to VarChar SQL
Sql :: mysql update add to existing value
Sql :: mysql clear screen
Sql :: mysql remove html tag
Sql :: sql pagination
Sql :: check postgresql version in rails console
Sql :: mysql auto increment after delete
Sql :: how to copy data in sql
Sql :: mysql delete duplicate rows but keep one
Sql :: postgresql append array
Sql :: use group_concat in concat
Sql :: sql count null values in all columns
Sql :: how to check if a column is null in sql
Sql :: check database size in gb mysql

Search

SQL

show constraints mysql

ADD CONTENT