Home / Software / Tips and Tricks / IN SQL Server how to get all the Tables with or without Primary Key Constraint?

IN SQL Server how to get all the Tables with or without Primary Key Constraint?

Updated:  05/24/2016 13:05 PM
Author:  Shiju Mathews

Status:    Resolved.


For listing all the tables with Primary Key Constraint, use the following query.



For listing all the tables with no Primary Key Constraint, use the following query.