Question

write a script on how to Create a table name school, using sql

Answer 1

Answer:

Explanation:

CREATE TABLE School

(

column1 data_type(size),

column2 data_type(size),

column3 data_type(size),

....

);

column1 name of the first column.

data_type: Type of data we want to store in the particular column.  

           For example,int for integer data.

size: Size of the data we can store in a particular column. For example if for

a column we specify the data_type as int and size as 10 then this column can store an integer

number of maximum 10 digits.