Saturday, February 25, 2012

display/show tablename

hi,
anybody know if it is possible to display only the table names? I would like to run a query that display the table names...
thanksTake a look at the sysobjects table in the sql books online. Here is an example of a query that will return user tables from a database:

select * from sysobjects where xtype = 'U'

No comments:

Post a Comment