Hi ,
I have written below sql in src/main/resources/schema.sql :
CREATE TABLE Player ( ID INTEGER NOT NULL,
Name VARCHAR(255) NOT NULL,
Nationality VARCHAR(255) NOT NULL,
Birth_date TIMESTAMP,
Titles INTEGER, PRIMARY KEY (ID));
application.properties
server.port = 8000
spring.datasource.url = jdbc:h2:mem:testdb
spring.h2.console.enabled = true
I restarted the application but the table is not reflecting in my H2 console(http://localhost:8000/h2-console/login.do?jsessionid=621b113cee5aa734523d374fe879222f) .
Please help .