Sql

Search

how to check table name in current database sql

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name() 
and TABLE_NAME like'%table_name%'--to check particular table

Comment

PREVIOUS	NEXT

Code Example
Sql :: inner join distinct
Sql :: flask sqlalchemy update row
Sql :: oracle table free space
Sql :: sql select count distinct
Sql :: python uuid sqlalchemy
Sql :: current date in sql
Sql :: postgres user permissions
Sql :: SQL Modify Column in a Table -PostgreSQL
Sql :: mysql order by multiple columns
Sql :: ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql
Sql :: mysql count by month
Sql :: installing mysql on centos 7
Sql :: SQL: get date difference in minutes
Sql :: mysql auerries to find the name starting with vowel letter
Sql :: get the location of where postgres database is stored
Sql :: sql find table by name
Sql :: sub query in linq
Sql :: sql alter table order by
Sql :: charindex
Sql :: min max sql
Sql :: how to get initials in sql
Sql :: update column value in sql
Sql :: select from select sql server
Sql :: image for MSSQL Windows Docker
Sql :: SQL Subtraction Operator
Sql :: select last n rows mysql
Sql :: sql values to array of objects
Sql :: location of the log postgresql linux
Sql :: sqlalchemy bulk delete
Sql :: remove last characters in mysql

Search

SQL

how to check table name in current database sql

ADD CONTENT