New answers tagged constraint
0
votes
How to list all constraints of a table in PostgreSQL by schema?
You can execute this query
select distinct 'Alter table '||c.conrelid::regclass||' Add CONSTRAINT '||c.conname||' '||
pg_get_constraintdef(c.oid)||';'
FROM pg_constraint c
...
Top 50 recent answers are included
Related Tags
constraint × 476postgresql × 147
sql-server × 135
foreign-key × 101
database-design × 91
mysql × 73
index × 40
oracle × 33
check-constraints × 32
unique-constraint × 30
primary-key × 23
sql-server-2008 × 18
sql-server-2008-r2 × 18
ddl × 15
sql-server-2014 × 14
trigger × 14
referential-integrity × 13
alter-table × 12
null × 12
sql-server-2005 × 10
sqlite × 9
default-value × 9
sql-server-2012 × 8
innodb × 8
schema × 8