locked
question regarding SQL Server RRS feed

  • 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
    GO

    Monday, 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