question regarding SQL Server

Question

User-1416414389 posted

THis question is regarding SQL Server Database. I am having a database in which i am having more than 50 tables. I want to know the names of all the tables. Is there any command for these query.

Thanx in advance.

Rakesh Sharma

Answer 1

User-788007034 posted

run this command

USE YourDBName
GO 
SELECT *
FROM sys.Tables
GO

Answer 2

User-451195045 posted

hi try this command 

select * from information_schema.tables

hope help you

Answer 3

User-366017857 posted

Use this query

USE YourDBName
GO
SELECT *
FROM sys.Tables
GO

Answer 4

User758008437 posted

USE db-name

 

GO

SELECT *

FROM sys.Tables

GO

Answer 5

User1255597977 posted

Find table Details

select * from information_schema.tables
where Table_Type='Base Table'

Hope it will help u..