programiz.com, as data

To fix this issue, we can add the optional `IF NOT EXISTS` command while creating a table.`-- create a Companies table if it does not existCREATE TABLE IF NOT EXISTS Companies (Here, the SQL command checks if a table named Companies exists, and if not, it creates a table with specified columns.## Create Table Using Another Existing TableIn SQL, we can create a new table by duplicating an existing table's structure.`-- create a backup table from the existing table CustomersCREATE TABLE CustomersBackupThis SQL command creates the new table named CustomersBackup, duplicating the structure of the Customers table.**Note**: You can choose to copy all or specific columns.## More on CREATE TABLECreate a table with a Primary KeyTo create a table with a primary key, we can write the following command.To learn more, visit SQL PRIMARY KEY.Define constraints while creating a tableWe can also add different types of constraints while creating a table. For example,Here, the constraint `NOT NULL` is added to the columns id, name and email. It simply means, these columns can't be **empty** (**NULL**).To learn more, visit SQL Constraints.**Note:** Sometimes these constraints are database specific, meaning that these keywords may vary database to database.Create a new filtered table from an existing tableWe can create a new table by extracting specific rows from an existing table based on certain criteria. We can make use of SELECT and WHERE clauses. For example,`CREATE TABLE USACustomers ASHere, we created a new table `USACustomers` with all the customer data from the `USA`.### Table of Contents* Create Table Using Another Existing Table[](<https://twitter.com/intent/tweet?text=Check this amazing article on SQL CREATE TABLE : &via=programiz&url=https://www.programiz.com/sql/create-table>)[](<https://api.whatsapp.com//send?text=Check+this+amazing+article+on+SQL CREATE TABLE :+https://www.programiz.com/sql/create-table>)