简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
How to determine whether the database libraries and tables exist?
正念的奇迹
正念的奇迹 2017-08-08 10:47:41
0
2
1187

As the question goes, how to determine whether the database libraries and tables exist?

正念的奇迹
正念的奇迹

继续学习奋勇向前

reply all(2)
大家讲道理
大家讲道理2017-08-08 14:16:12 2 floor

if exists(select*from sysobjects where name ='bbsUsers' )
drop table bbsUsers

bbsUsers is the table to be queried

sysobjects is the system table

Like +0
Add Reply
ringa_lee
ringa_lee2017-08-08 14:15:49 1 floor

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

Like +0
Add Reply
Popular Topics
More>
Popular Articles
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！