当前位置：网站首页>If MySQL / SQL server judges that the table or temporary table exists, it will be deleted

If MySQL / SQL server judges that the table or temporary table exists, it will be deleted

2022-04-23 02:42:00 【An effort to XX program yuan】

MySQL

  1. Delete if the table exists ,table_name It's the name of the watch 
DROP TABLE IF EXISTS table_name;

SQL Server

  1. If it is judged that the temporary table exists, delete ,#temp Is the name of the temporary table 
if object_id('tempdb..#temp') is not null
drop table #temp
  1. Delete if the table exists ,t_table It's the name of the watch 
if object_id('t_table') is not null
drop table t_table

版权声明
本文为[An effort to XX program yuan]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230239165436.html

边栏推荐

猜你喜欢

随机推荐