YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: DDL

YugabyteDB Tips > DDL

Expanding Pure SQL Table DDL Export in YugabyteDB: Indexes, Constraints, Triggers, and Partitions

Jim KnicelyMay 7, 2026

In a previous YugabyteDB Tip, we built a pure SQL function to export a table’s CREATE TABLE DDL directly from YugabyteDB system […]

Read More

How to Protect Your Database from Accidental DROP DATABASE

Jim KnicelyApril 23, 2026

🚨 The Problem Today a customer asked a great (and very real) question: “What if a DBA accidentally runs DROP DATABASE on […]

Read More

Fixing Unintentionally Range-Sharded Tables in YugabyteDB

Jim KnicelyApril 2, 2026

If you upgraded into the YugabyteDB 2024.1 era and enabled Enhanced PostgreSQL Compatibility Mode, there is an easy mistake to miss: You […]

Read More

Export YugabyteDB CREATE TABLE DDL Using Pure SQL (Including SPLIT AT and SPLIT INTO)

Jim KnicelyMarch 16, 2026

Intro To export schema from YugabyteDB, the most common approach is to use the ysql_dump utility: ysql_dump –include-yb-metadata This produces DDL that […]

Read More

Posts navigation

Older posts

NOTICE

This site is not affiliated, endorsed or associated with YugabyteDB. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.

Find Us

Address
Here!

Hours
24×7

Recommended YugabyteDB Links

  • Home
  • Key Concepts
  • Docs
  • Blog
  • Forum
  • Content Library
  • Support



YugabyteDB Tips

Copyright 2025 - Knicely/Li