What is the SQL CREATE TABLE Statement?
The SQL CREATE TABLE statement is the SQL command that adds a new table to an SQL database. Tables are a basic unit of organization and storage of data in SQL. Each table tends to represent an entity such as a customer, product, code or event. A table is similar to a file in a non-database system. Tables are organized into rows and columns. For example, a customer table would likely have a seperate row for each customer. Columns are attributes that describe a row. For example, a row in a customer table would have columns like customer_name, customer_nbr, account_balance_amt and established_date. Why Use the SQL CREATE TABLE Statement? Anytime you want to add a new table to the database you would use the SQL CREATE TABLE statement. How To Use the SQL CREATE TABLE Statement The SQL CREATE TABLE command is used as follows. SQL CREATE TABLE Statement Syntax CREATE TABLE
