How to identify list of tables with doesnt have PK in its DDL ?
Identify tables without primary key
+1
Did you check
select * from v_catalog.tables t where t.table_name not in
(
select table_name from v_catalog.primary_keys
)
?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
