+ 4
How to create table in database
sql
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
+ 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.
+ 1
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
Good Luck!
0
IBM DB2 Database:
CREATE TABLE <Tablename> (<Fieldname1> DOUBLE, <Fieldname2> TEXT, ...);
0
I think it's a perfect answer from Rafey Iqbal Rahman ..
just a little note.. don't forget the constraints.
0
ADIL GAAFER thanks for appreciating me and improving my knowledge.