how to find unknown table name from databas

[nirmalsingh]

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

[willakawill]

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

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

[nirmalsingh]

Hi. This will do the trick

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

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

[Anu139]

Hi. This will do the trick

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_schema.tables