How do you create a table? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

How do you create a table?

6th Oct 2016, 10:51 PM
compscinerd
compscinerd - avatar
7 Answers
+ 2
Using create table command whose syntax is Create Table < Table Name > ( <Column name > < column definition>,.........) ;
7th Oct 2016, 4:30 AM
Abhinandan Jain
Abhinandan Jain - avatar
+ 2
create table <TABLE_NAME>(columnname datatype, next CN DATATYPE);
13th Oct 2016, 11:26 AM
sahitya dubey
sahitya dubey - avatar
+ 1
using create table name table_name
7th Oct 2016, 12:26 AM
Erwin Hermanto
Erwin Hermanto - avatar
+ 1
You can use the existing column format in the database by copying the wholw relation to create your own. Create table <your table name> as Select* <or any desire columns> from <existing table name>;
7th Oct 2016, 5:24 AM
Michael Winson
Michael Winson - avatar
+ 1
create table tablename ( column_name data type(size), column_name data type(size), ........ );
14th Oct 2016, 6:24 AM
sabarmathi
0
thanks everyone
7th Oct 2016, 6:22 AM
compscinerd
compscinerd - avatar
0
create table (table_name);
21st Nov 2016, 3:47 AM
Arun Bhandari
Arun Bhandari - avatar