Skip to content

Instantly share code, notes, and snippets.

@hancheester

hancheester/find-all-objects-in-mssql-schema.sql

Last active November 8, 2019 22:57
Show Gist options
  • Save hancheester/d7525b08b8c954946543c4f24eff5c38 to your computer and use it in GitHub Desktop.
Save hancheester/d7525b08b8c954946543c4f24eff5c38 to your computer and use it in GitHub Desktop.
Download ZIP
To find all objects in SQL Server schema.
Raw
find-all-objects-in-mssql-schema.sql
-- To find all objects in SQL Server schema
select * from sys.objects
where schema_id = SCHEMA_ID('dbo');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment