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.

Tags: IN SQL Server how to get all the Tables with or without Primary Key Constraint?
Updated on: March 2024