All the clauses and operations in SQL can only be performed in the presence well-designed table. Creating a table involves defining the columns and the datatype for every particular column. The CREATE TABLE in SQL is used to generate a new enumeration in the database.
- Syntax to CREATE TABLE –
CREATE TABLE table_name
(column1 datatype,
column2 datatype,
column3 datatype,
....,
columnN datatype);
Here the syntax has the different columns that show the different names for the columns in the new table whereas the data types specify what type of data will be associated with each column.
Example – Let’s create a table name as Customers which has the “ID” column as the primary key and should have NOT NULL as its constraints. The following table will have 5 columns i.e.- “ID”,”FirstName”,”LastName”,”Age”,”City”.
- NOT NULL constraints limit the fields not to have NULL as it’s any of the values.
CREATE TABLE Customers
(ID int NOT NULL,
LastName varchar(255),
FirstName varchar(255),
Age int,
City varchar (255),
PRIMARY KEY (ID));
Right now if we run the SELECT statement with this table, there will be no value as we have not yet inserted any values in the table.
Other SQL topics to check out:
- What is RDBMS (Relational Database Management System)?
- SQL SELECT Statement
- SQL INSERT INTO SELECT Statement
- SQL ALL Operator
- SQL WHERE Clause
- SQL AND Operator
- SQL OR Operator
Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.
If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.
#analytics #data #business #artificialintelligence #machinelearning #startup #deeplearning #deeplearning #datascience #ai #growth #dataanalytics #india #datascientist #powerbi #dataanalysis #tableau #SQL #businessanalytics #businessanalyst #businessandmanagement #dataanalyst #businessanalysis #analyst #analysis #powerbideveloper #powerbidesktop #letsviz
