YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: System Tables

YugabyteDB Tips > System Tables

Pitfalls of Adding a PK to an Existing Table in YSQL

Jim KnicelyNovember 24, 2022

Although it’s possible to add a primary key constraint to an existing table with the ALTER TABLE ADD CONSTRAINT command, it’s best […]

Read More

Drop a YCQL Keyspace Which is Not Empty

Jim KnicelyOctober 12, 2022

In YCQL the DROP KEYSPACE statement is used remove a keyspace from the system. An error is raised if the specified keyspace […]

Read More

Display All Universe Node IPs from YCQL

Jim KnicelySeptember 13, 2022

A YugabyteDB universe is comprised of exactly one primary cluster and zero or more read replica clusters. In YCQL we can display […]

Read More

EXPORT TABLE DDL (FROM YSQL)

Jim KnicelyJuly 18, 2022

In YSQL you can display the structure of a table, including indexes and constraints, by issuing the d table_name meta-command. yugabyte=# CREATE […]

Read More

Posts navigation

Older posts
Newer 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