· 6 years ago · Mar 05, 2019, 04:46 PM
1%%sql
2def dropcreate_CUSTOMERS(conn):
3 DROP TABLE IF EXISTS CUSTOMERS
4 CREATE TABLE CUSTOMERS(
5 ID INT NOT NULL,
6 NAME VARCHAR (20) NOT NULL,
7 AGE INT NOT NULL,
8 ADDRESS CHAR (25) ,
9 SALARY DECIMAL (18, 2),
10 PRIMARY KEY (ID)
11)