- - çíàííÿ MySQL.
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname' AND TABLE_NAME = 'tablename'
Çíà÷åííÿ dbname ³ tablename ïîòð³áíî çàì³íèòè íà âàø³ íàçâè. Ïðè íåîáõ³äíîñò³ ñòâîðèòè çãîäîì òàáëèöþ, ÿêùî òàêà íå áóëà çíàéäåíà, âèêîðèñòîâóéòå êîìàíäó âèäè:
CREATE TABLE IF NOT EXISTS
SELECT COUNT (*) FROM msysobjects WHERE type = 1 AND name = 'tablename'
ßêùî âàì ïîòð³áíî âèäàëèòè òàáëèöþ, ÿêùî âîíà áóäå çíàéäåíà, òî ñêëàä³òü çàïèò íàñòóïíèì ÷èíîì:
DROP TABLE IF EXISTS table-