Press CTRL+C to copyrunSql("CREATE VIEW AlbertaAddresses AS SELECT * FROM sakila.address WHERE district = 'Alberta'"); //check TABLES for successful CREATE VIEW runSql("SHOW TABLES LIKE 'AlbertaAddresses' ", function (ResultSetData) { print(ResultSetData); });
The output is:
[ { "Tables_in_sakila (AlbertaAddresses)": "albertaaddresses" } ]
Press CTRL+C to copyrunSql("DROP VIEW IF EXISTS albertaaddresses"); //check TABLES for successful DROP VIEW runSql("SHOW TABLES LIKE 'A%' ", function (IResultSetData) { print(IResultSetData); });
The output is:
[ { "Tables_in_sakila (A%)": "actor" }, { "Tables_in_sakila (A%)": "actor_info" }, { "Tables_in_sakila (A%)": "address" } ]