+ 4

How to create table in database

sql

17th Jul 2018, 6:45 AM
Hemant Sharma
Hemant Sharma - avatar
6 Réponses
+ 4
Hello, Hemant Lawaniya ! It looks like a suitable lesson was found for you. Good luck with programming on SoloLearn! https://www.sololearn.com/learn/SQL/1870/?ref=app
17th Jul 2018, 7:36 AM
Alexander Sokolov
Alexander Sokolov - avatar
+ 1
The fundamental syntax of creating a table in a database is: CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), .... columnN data_type(size) ); - The column_names specify the names of the columns we want to create. - The data_type parameter specifies what type of data the column can hold. For example, use int for whole numbers. - The size parameter specifies the maximum length of the table's column.
17th Jul 2018, 1:49 PM
Rafey Iqbal Rahman
Rafey Iqbal Rahman - avatar
+ 1
CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... ); Good Luck!
18th Jul 2018, 11:26 PM
Christopher Conlon
Christopher Conlon - avatar
0
IBM DB2 Database: CREATE TABLE <Tablename> (<Fieldname1> DOUBLE, <Fieldname2> TEXT, ...);
17th Jul 2018, 11:57 AM
Mindshadow
Mindshadow - avatar
0
I think it's a perfect answer from Rafey Iqbal Rahman .. just a little note.. don't forget the constraints.
17th Jul 2018, 4:32 PM
ADIL GAAFER
ADIL GAAFER - avatar
0
ADIL GAAFER thanks for appreciating me and improving my knowledge.
17th Jul 2018, 5:30 PM
Rafey Iqbal Rahman
Rafey Iqbal Rahman - avatar