how can i find the table names

Expand Post »

how can i find the table names from Sql server. what r the statement.

Similar Threads

Fields in an Access database table in VB.NET
finding duplicate names in Oracle
script to find function names in Shell Scripting
How to retrieve table names in MS SQL
populate dropdown list with table names in ASP.NET

else_harpal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2009

Permalink

Oct 28th, 2009

Re: how can i find the table names

MS SQL Syntax (Toggle Plain Text)
USE DATABASE_NAME
 
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
use DATABASE_NAME

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES

Thirusha

Reputation Points: 36

Solved Threads: 57

Posting Whiz

Offline

355 posts
since Mar 2008

Permalink

Oct 29th, 2009

Re: how can i find the table names

I didn't know about INFORMATION_SCHEMA.Tables

I have used this in the past:

MS SQL Syntax (Toggle Plain Text)
SELECT name
FROM sysobjects
WHERE Type = 'u'
Select name
From sysobjects
Where Type = 'u'

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Connection Strings to network.

Next Thread in MS SQL Forum Timeline: View Help

DaniWeb Message

Cancel Changes

User Name
Password