Jump to content

query analyzer question


Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...