how can you know the tables in the particular database can you help me out for that utitliy or query or stored procedure

shahbaz b. subedar

http://msdn.microsoft.com/library/de...asp?frame=true

This sort of question belongs in the Database - SQL Server forum.


--

Joe (Microsoft MVP - XML)

lets say u have database name 'pubs'

in query analyzer type and execute and u can see the user tables as well as others relevanet msgs.
use pubs
sp_help

for a particular database you can query the sysobjects table as follows:

select * from sysobjects where type = 'u' order by name

For the pubs database, this will return the names of the user tables.