Enroll in PostgreSQL Courses
Get Started
Use Code 'DBGRP30' for 30% OffCategory
-
Join 160 other subscribers
Top Posts & Pages
Archives
-
Recent Posts
- Why Ora2Pg Should Be Your First Stop for PostgreSQL Conversion March 31, 2026
- Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About! March 27, 2026
- PostgreSQL Sequence Reset: START WITH vs RESTART WITH vs SETVAL Explained March 21, 2026
- PGConf India 2026: PostgreSQL Query Tuning: A Foundation Every Database Developer Should Build March 13, 2026
- Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug January 30, 2026
- PostgreSQL Table Rename and Views – An OID Story January 5, 2026
- PostgreSQL Partition Pruning: The Role of Function Volatility November 4, 2025
- Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly September 28, 2025
- PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collations September 6, 2025
- PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease May 10, 2025
- Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson November 10, 2024
- PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood. November 2, 2024
-
Enhance your PostgreSQL skills! Master Database Development and Migration with my course. Click here to start!
Tag Archives: query
Generate Script for Foreign key’s in SQL Server.
During conducting one of the Proof Of Concept around “InMemory“, we had to disable foreign key to use Migration wizard provided by SSMS. Before disable, we had to create script for all foreign key for multiple tables in Database and … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged alter, create, disable, drop, enable, foreign key, query, script, SQL, sql server
Leave a comment
Database and Migration Insights 
