Understanding SQL Server's sysobjects table

Monday Dec 18th 2006 by DatabaseJournal.com Staff

Learn why knowledge of the SQL Server sysobjects table can come in handy in certain situations.

[From Builder.com]

Everything about your SQL Server database is stored in its system tables. I doubt that you spend a lot of time inspecting the system tables since you are too busy with your user tables. However, you may need to do something unusual once in a while, such as list all the triggers in your database. You could inspect your tables one by one, but that can become quite labor intensive if you have 500 tables.

The article continues at http://builder.com.com/5100-6388_14-6142579.html?tag=sc

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved