How to check whether table is present in work db
Asked by Sapna Last Modified
Follow 3 
Answer 
First way: IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA. ... Second way: IF OBJECT_ID (N'mytablename', N'U') IS NOT NULL SELECT 1 AS res ELSE SELECT 0 AS res; MySQL provides the simple: SHOW TABLES LIKE '%tablename%';
0
Comments
Related Questions
What should be the fees for Online weekend Big Data Classes. All stack Hadoop, Spark, Pig, Hive , Sqoop, HBase , NIFI, Kafka and others. I Charged 8K and people are still negotiating. Is this too much? 
Based on experience we can demand and based on how many hours you are spending for whole course. But anyway 8K is ok. But some of the people are offering 6k. So they will ask. Show your positives compare...
11Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
Loading Hive tables as a parquet File
Hive tables are very important when it comes to Hadoop and Spark as both can integrate and process the tables in Hive. Let's see how we can create a hive table that internally stores the records in it...
Lets look at Apache Spark's Competitors. Who are the top Competitors to Apache Spark today.
Apache Spark is the most popular open source product today to work with Big Data. More and more Big Data developers are using Spark to generate solutions for Big Data problems. It is the de-facto standard...
B
IoT for Home. Be Smart, Live Smart
Internet of Things (IoT) is one of the booming topics these days among the software techies and the netizens, and is considered as the next big thing after Mobility, Cloud and Big Data.Are you really aware...
K
Big Data & Hadoop - Introductory Session - Data Science for Everyone
Data Science for Everyone An introductory video lesson on Big Data, the need, necessity, evolution and contributing factors. This is presented by Skill Sigma as part of the "Data Science for Everyone" series.
Big Data for Gaining Big Profits & Customer Satisfaction in Retail Industry
For any business, the key success factor relies on its ability for finding the relevant information at the right time. In this digital world, it has become further crucial for the retailers to be aware...
K
Looking for Apache Spark ?
Learn from the Best Tutors on UrbanPro
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near you
