Advertisement
econz

Firebird - Tabelas sem Chave Primária (PK)

May 15th, 2015
352
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | None | 0 0
  1. SELECT
  2.    RDB$RELATION_NAME AS TABELA_SEM_PK
  3. FROM RDB$RELATIONS
  4. WHERE
  5.    COALESCE(RDB$RELATION_TYPE,0) IN ( 0, 4, 5 ) AND
  6.    ( RDB$SYSTEM_FLAG = 0 OR RDB$SYSTEM_FLAG IS NULL ) AND
  7.  
  8.    RDB$RELATION_NAME NOT IN (
  9.       SELECT RDB$RELATION_NAME FROM RDB$RELATION_CONSTRAINTS WHERE RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  10.    )
  11. ORDER BY RDB$RELATION_NAME
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement