MS SQL

how can i find the table names

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 1

Reputation: else_harpal is an unknown quantity at this point

Solved Threads: 0

else_harpal else_harpal is offline

Offline

Newbie Poster

how can i find the table names

-1

Oct 26th, 2009

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

•

Join Date: Mar 2008

Posts: 318

Reputation: Thirusha is an unknown quantity at this point

Solved Threads: 51

Thirusha

Offline

Posting Whiz

Oct 28th, 2009

 Help with Code Tags 
 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

Life... Is a Moment

•

Join Date: Feb 2009

Posts: 3,472

Reputation: sknake has much to be proud of

Solved Threads: 629

sknake

Offline

.NET Enthusiast

Oct 29th, 2009

I didn't know about INFORMATION_SCHEMA.Tables

I have used this in the past:

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

Scott Knake
Custom Software Development
Apex Software, Inc.

Quick Reply to Thread

Show Printable Version

Similar Threads

Fields in an Access database table (VB.NET)
finding duplicate names (Oracle)
script to find function names (Shell Scripting)
How to retrieve table names (MS SQL)
populate dropdown list with table names (ASP.NET)
Retrieve values from sql server 2005 (ASP.NET)
New to the forum / World countries table (Database Design)

Other Threads in the MS SQL Forum

Previous Thread: Connection Strings to network.
Next Thread: View Help

Views: 385 | Replies: 2

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes