SQL 10. Managing Tables & Databases
In previous posts, we focused on querying tables. In this post, we’ll explore data definition in SQL: how to create, modify, and delete database objects like tables, constraints, and databases themselves. Mastering these operations shows that you not only know how to query data, but also how to design and manage the structures that hold it. We’ll cover: Data types Constraints Primary and foreign keys Creating and altering tables and databases We’ll cover views, indexes, and data manipulation (INSERT, UPDATE, DELETE) in separate posts. ...