Is there any sql query to check if a table exists already in a database?
Thanks in advance.:)
Jump to Post
select count(*) from information_schema.tables where table_name='SEARCH_TABLE_NAME' AND TABLE_SCHEMA='SEARCH_DATABASE_NAME'
If you want to create new table you may also use
create or replace syntax........
All 8 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.