How to create a query in the database management system?
Answers
Answered by
3
Creating a Table
create command can also be used to create tables. Now when we create a table, we have to specify the details of the columns of the tables too. We can specify the names and datatypes of various columns in the create command itself.
Following is the syntax,
CREATE TABLE <TABLE_NAME> ( column_name1 datatype1, column_name2 datatype2, column_name3 datatype3, column_name4 datatype4 );
create table command will tell the database system to create a new table with the given table name and column information
create command can also be used to create tables. Now when we create a table, we have to specify the details of the columns of the tables too. We can specify the names and datatypes of various columns in the create command itself.
Following is the syntax,
CREATE TABLE <TABLE_NAME> ( column_name1 datatype1, column_name2 datatype2, column_name3 datatype3, column_name4 datatype4 );
create table command will tell the database system to create a new table with the given table name and column information
Similar questions