Interview Questions
1. Explain the usage of below procedures
- sp_helpindex [tablename] – shows you index info (same info as sp_help)
- sp_helpconstraint [tablename] – shows you primary/foreign key/defaults and other constraints
- sp_depends [objname] – shows dependencies of an object.
- sp_depends [tablename] – shows you what stored procs, views, triggers, UDF affect this table.
- sp_depends [storedprocname] – shows what tables etc. are affected/used by this stored proc.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment