CODEWITHSUNDEEP
sql-server-2005
Vijay
Vijay

Reputation: 1

Need a query to find all the objects in a database?

I need a query to find all the objects tables,stored procedure,trigger,indexes,function in sql server?

Upvotes: 0

Views: 32

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300579

USE MyDB
GO

select * from sys.objects
GO

Upvotes: 1

Related Questions