SELECT name, type_desc FROM sys.objects WHERE type IN ('U', 'V', 'P'); -- U=Table, V=View, P=Procedure Use code with caution. Copied to clipboard
The phrase "guide looking into famor (2).sql" appears to be a reference to a specific file or course material, likely from the series, which is a popular hands-on SQL guide for beginners. famor (2).sql
: You can often find accompanying scripts and downloads for their books there. SELECT name, type_desc FROM sys
: DESCRIBE table_name; or EXEC sp_help 'table_name'; (in SQL Server). Finding Existing Objects : : DESCRIBE table_name; or EXEC sp_help 'table_name'; (in
: Sites like SlideShare often host converted versions of these beginner guides.
: Many online repositories and PDFs for this course include .sql files designed to help students "look into" or explore existing table structures, primary keys, or foreign keys. Typical "Looking Into" SQL Queries
: Volume 2 of this series typically covers objects like Views, Stored Procedures, and Functions . A "guide looking into" these would involve scripts that query system metadata to see how these objects are structured.