NYCPlanning / db-cpdb

Capital Projects Database
https://nycplanning.github.io/db-cpdb
0 stars 0 forks source link

DROP VIEW in sql queries #115

Closed td928 closed 1 year ago

td928 commented 2 years ago

There are a few scripts start with DROP VIEW but immediately followed by CREATE TABLE. This would cause an issue mostly when local testing is performed when the database does not start from a "clean slate' and existing table won't get properly dropped and new table cannot replace the existing ones.