How to create table in database

Question

sql

Answer 1

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

Answer 2

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.

Answer 3

CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);

Good Luck!

Answer 4

IBM DB2 Database:

CREATE TABLE <Tablename> (<Fieldname1> DOUBLE, <Fieldname2> TEXT, ...);

Answer 5

I think it's a perfect answer from Rafey Iqbal Rahman ..
just a little note.. don't forget the constraints.

Answer 6

ADIL GAAFER thanks for appreciating me and improving my knowledge.