Skip to main content

Cockroach University: Creating and Modifying a Table

In this Cockroach University lesson titled "Creating and Modifying a Table”, you’ll learn how to create a simple database and table. Then will discuss how to see a table’s schema, and how to modify the schema of a table. In this lesson, you will learn to: •Create a database and table •Define the primary key of a table at creation •Create a table with a composite primary key •View a table's schema •Modify the schema of an existing table Learn more about CockroachDB by signing up for free training at Cockroach University https://university.cockroachlabs.com/ --------------------------------------------------------------------------------------------------------------------------- Reference Links •CREATE TABLE https://www.cockroachlabs.com/docs/stable/create-table.html(CockroachDB Docs) •ADD COLUMN https://www.cockroachlabs.com/docs/stable/add-column.html(CockroachDB Docs) •ALTER TABLE https://www.cockroachlabs.com/docs/stable/alter-table.html (CockroachDB Docs) •Column Families https://www.cockroachlabs.com/docs/stable/column-families.html (CockroachDB Docs) --------------------------------------------------------------------------------------------------------------------------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB