query analyzer question

[tariq_ews]

Hello Guys,I wanna show my all tables and there creation and modification date with single queryAny one tell meRegards,Tariq

[Reg Edit]

Hello Guys,I wanna show my all tables and there creation and modification date with single queryAny one tell meRegards,Tariq

In SQL 2005 this would be:

select * from sys.objects

As you mention Query Analyzer it sounds as though you're using SQL 2000, in which case you'll need to use sysobjects (one word) instead of sys.objects, but I seem to remember the sysobjects table includes that info too.

[tariq_ews]

ok i find it out using this query in xtype

select * from sysobjects where type='u'

thanks dear Reg Edit