Determine whether the table exists in MySQL and sqlserver statements _ MySQL

Statement bitsCN.com used to determine whether a table exists in MySQL and sqlserver

Determine whether a table exists in MySQL and sqlserver

MySQL:

Select count (*) FROM information_schema. tables where TABLE_NAME = "table name ";

// Double quotation marks

If the value is 1, the table exists. if the value is 0, the table does not exist.

Sqlserver:

Select 1 from sysobjects where name = 'Table name ';

If the value is 1, the table exists. if the value is null, the table does not exist.

BitsCN.com