Posts

Showing posts from September, 2023
Image
                       CREATE TABLE We use sql   CREATE TABLE   statement to create table in a database. Sql statement is used to create  table, delete table,  insert  and update  table,delete data in table . T he structure consists of the name of a table and names of columns in the table with each column's data type. The datatype specifies the type of data the column can hold (e.x. varchar, integer, date, etc . ).     syntax of the SQL  CREATE TABLE  statement is: create   table   table_name(    column1   data type ,   column2   data type ,   column3   data type ,  column4   data type , ...  columnN   data type );   NOTE ➗ •    Column   → The column specify the names of the columns of the table. •    table_name → it is the name of the  table. •...