From the course: Database Foundations: Intro to Databases
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Reserved keywords
From the course: Database Foundations: Intro to Databases
Reserved keywords
- [Instructor] The SQL language includes a large number of commands and other keywords that have special meaning to the database engine. We've already seen a few of them, words like Create, Alter, Schema, Table. These command keywords, instruct the server to do something, to build something or edit something. Words like these are called reserved keywords, and it's important to avoid using them in the names of your database objects, like tables or columns. It can be downright confusing to read if you do use these reserved keywords as object names. Consider the command create table, create.table. Here we're asking for a table named table and a schema named create. While you can kind of make sense of what's going on, it's a struggle. Worse, the database engine can get confused as it tries to interpret what you're asking for. In fact, in order to actually accomplish this task, you'd have to wrap the names in square brackets…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Structured Query Language4m 9s
-
(Locked)
Organize a database with schemas6m 4s
-
(Locked)
Table columns3m 41s
-
(Locked)
Create tables8m 43s
-
(Locked)
Alter tables4m 16s
-
(Locked)
Reserved keywords3m 1s
-
(Locked)
Challenge: Create a table43s
-
(Locked)
Solution: Create a table4m 35s
-
(Locked)
Solution: Tables and data types2m 48s
-
(Locked)
-
-
-
-