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
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
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...
Hadoop v/s Spark
1. Introduction to Apache Spark: It is a framework for performing general data analytics on distributed computing cluster like Hadoop.It provides in memory computations for increase speed and data process...
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
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.
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
