fork download
copy 
  1. SELECT C.COLUMN_NAME FROM information_schema.table_constraints AS pk
  2.   INNER JOIN information_schema.KEY_COLUMN_USAGE AS C ON
  3.     C.TABLE_NAME = pk.TABLE_NAME AND
  4.     C.CONSTRAINT_NAME = pk.CONSTRAINT_NAME AND
  5.     C.TABLE_SCHEMA = pk.TABLE_SCHEMA
  6. WHERE  pk.TABLE_NAME  = 'test' AND pk.TABLE_SCHEMA = 'test_db'
  7.     AND pk.CONSTRAINT_TYPE = 'PRIMARY KEY';
Success #stdin #stdout #stderr 0s 3448KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: no such table: information_schema.table_constraints
https://ideone.com/mWcu21
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!