As the question goes, how to determine whether the database libraries and tables exist?
继续学习奋勇向前
if exists(select*from sysobjects where name ='bbsUsers' )drop table bbsUsersbbsUsers is the table to be queried sysobjects is the system table
You have an operation to connect to the database in the program. If there is no table or library, there will be an error message
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
if exists(select*from sysobjects where name ='bbsUsers' )
drop table bbsUsers
bbsUsers is the table to be queried
sysobjects is the system table
You have an operation to connect to the database in the program. If there is no table or library, there will be an error message