In this article we learn using sp_help system procedure. This procedure using for getting summary information of object listed in sys.objects table. We use this command when there is no visual interface(management studio or others) or we don't want to use mouse :)
If you want to get all summary information for all objects currently used database then you can use sp_help with no arguments.
EXEC sp_help
Result:
Usally i use this procedure for get information of tables. When used sp_help command with table name argument then result sets are depended objects of specified table. Result sets contain columns, identity columns,
rowguidcol value, file groups, indexes, constrains and tables are referenced by foreing key.
Using:
EXEC sp_help Tags
Result:
ebf84b5e-38ef-4d9c-98c6-9b3854792785|0|.0