Thursday, March 13, 2008

Show tables in a database

If you want to know which tables are defined in a (MS) database you can enter this SQL query:

select name from sysobjects where xtype = 'U'
order by name

No comments: