Skip to content

Instantly share code, notes, and snippets.

@halityurttas

halityurttas/list-table-with-scheme.sql

Created June 23, 2021 22:39
Show Gist options
  • Save halityurttas/b825c62c5098c350910279a7752c84f1 to your computer and use it in GitHub Desktop.
Save halityurttas/b825c62c5098c350910279a7752c84f1 to your computer and use it in GitHub Desktop.
Download ZIP
List table with scheme (where in table names)
Raw
list-table-with-scheme.sql
select schema_name(t.schema_id) + '.' +
t.name as table_name,
t.create_date,
t.modify_date
from sys.tables t
where t.name IN (
'ABC'
)
order by table_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment