Table Names 1

[Ginka]

Is there a table that contains all the tables names??

And what about the temporal tables?

 

[hmckillop]

SELECT * FROM SYSOBjects Where xtype = 'u' --(user created tables)

or

SELECT * FROM INFORMATION_SCHEMA.TABLES

"I'm living so far beyond my income that we may almost be said to be living apart

 

[Ginka]

Thank you that is exactly what I need