From the course: SQL Queries Made Easy
Join today to access over 24,500 courses taught by industry experts.
Different ways to create tables - SQL Tutorial
From the course: SQL Queries Made Easy
Different ways to create tables
- [Instructor] In this video, we will be learning about the first DDL statement, that is CREATE statement. DDL stands for Data Definition Language. These statements are auto commit, which means once they are executed, the changes will be permanent and cannot be reverted back. This is the syntax for the CREATE statement. Tables which do not belong to this user are not in this user's schema. So we have to give schema_name.table_name instead of just giving the table_name. Schema is like owner's name. After creating a table, we can check for it by giving DESCRIBE table_name or DESC table_name. Now before we create a new table, let's understand what are constraints. Constraints are like rules to follow at table level or column level. We can define these constraints at the time of creation of a table or after the table has been created. Constraints prevent deletion of a table when there are dependencies on that…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.