how to find unknown table name from databas

**willakawill** · Nov 15 '06, 08:01 AM

Originally posted by nirmalsingh

i know database name but i couldn't find table names corresponding to the database in query analyzer. help me to solve.....

Hi. This will do the trick

Code:

USE YourDatabaseNameHere
SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

**nirmalsingh** · Nov 15 '06, 09:57 AM

Originally posted by willakawill

Hi. This will do the trick

Code:

USE YourDatabaseNameHere
SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

thank u mam, its working well. i am so much thankful to u.

**Anu139** · Nov 16 '06, 09:58 AM

Originally posted by willakawill

Hi. This will do the trick

Code:

USE YourDatabaseNameHere
SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

HI U CAN ALSO USE THE FOLLOWING CODE.,
IT WILL DISPLAY ALL THE USER TABLES......

select TABLE_NAME from information_sch ema.tables

Comment