Teresita Castro
SSCommitted
Points: 1568
More actions
July 14, 2008 at 11:05 am
#209841
Hi
I need to make a list of the views, tables, functions, triggers of a databases
How can I do that?
Thanks
Grant Fritchey
SSC Guru
Points: 397721
July 14, 2008 at 11:20 am
#842568
Access the INFORMATION_SCHEMA views. There's one for tables, columns, routines, parameters...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply