CourtesyIndia.com
Trusted since 2005.
 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.

Tips and Tricks

Interview Questions for C#

Interview Questions for ASP.Net

Interview Questions for SQL Server

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