How to Get all the Tables which has Primary Key Constraint Created in SQL Server Database - Part 57

SQL Server / T-SQL Tutorial Scenario:
You are working as SQL Server Developer/ SQL Server DBA in Auto Insurance Company. You are asked to provide a query that should return list of all the tables with Schema Name, Column Name and Primary Key Constraint which has primary key constraint created on them.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)

[mayurkharat]

Can you please tell how to remove primary key constraint temperarorily and again add after data dumping process?

[priyankaborkar]

how to check data type in target table ?data correction validation also