sql get tables from current database you working with

flybyadgsenpai answered on April 15, 2021 Popularity 6/10 Helpfulness 7/10

answer sql get tables from current database you working with

related get tables in database sql

sql get tables from current database you working with

Comment

-- note for Microsoft SQL Server
-- getting tables in database you are working with

DECLARE @dbname AS varchar(max)
SET @dbname = (SELECT DB_NAME())
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=@dbname

-- getting tables in specific database

DECLARE @dbname AS varchar(max)
SET @dbname = 'my specific database name'
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=@dbname

Popularity 6/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: database get sql

Link to this answer
Share Copy Link

Contributed on Jun 13 2022

flybyadgsenpai

0 Answers Avg Quality 2/10

Closely Related Answers

get tables in database sql

Comment

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;

Popularity 9/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Apr 15 2021

MelCode

0 Answers Avg Quality 2/10

sql get tables from current database you working with

Contents

More Related Answers

sql get tables from current database you working with

Closely Related Answers

get tables in database sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.