List tables only

[babeo]

Hi

Instead of using sp_tables to list all table names of a database including with other fields, I just want to list the table_name column only, or particular column. Is there a command or way to do that?

Thanks

 

[qyllr]

hello,

try...

select name
from sysobjects
where type = 'U'
go

q.

 

[babeo]

Thanks qyllr

 

[JMCraig]

If you want a specific column or columns, you can do this:

select table_name = object_name (id), name
from syscolumns
where name = 'the_column_name_you_want'

You can restrict that to a particular table or tables by adding a condition like this one:

and id = object_id ('the_table_in_question')

or, for several tables,

and id in (object_id ('table1'), object_id('table2'))

BOL,

John J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net