1.

How to create a query in the database management system?

Answer» 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 ( 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



Discussion

No Comment Found