Answered by:
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
Monday, April 16, 2012 7:41 AM
Answers
-
User-451195045 posted
hi try this command
select * from information_schema.tables
hope help you
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Monday, April 16, 2012 7:44 AM -
User-366017857 posted
Use this query
USE YourDBName
GO
SELECT *
FROM sys.Tables
GO- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Monday, April 16, 2012 7:44 AM
All replies
-
User-788007034 posted
run this command
USE YourDBName
GO
SELECT *
FROM sys.Tables
GOMonday, April 16, 2012 7:43 AM -
User-451195045 posted
hi try this command
select * from information_schema.tables
hope help you
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Monday, April 16, 2012 7:44 AM -
User-366017857 posted
Use this query
USE YourDBName
GO
SELECT *
FROM sys.Tables
GO- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Monday, April 16, 2012 7:44 AM -
User758008437 posted
USE db-name
GO
SELECT *
FROM sys.Tables
GO
Monday, April 16, 2012 7:58 AM -
User1255597977 posted
Find table Details
select * from information_schema.tables
where Table_Type='Base Table'
Hope it will help u..
Tuesday, April 17, 2012 3:31 AM