Skip to content

Instantly share code, notes, and snippets.

@4mitch

4mitch/MS SQL snippets.sql

Created August 31, 2017 12:51
Show Gist options
  • Save 4mitch/25e736d137aa92d27480720b7bb1679e to your computer and use it in GitHub Desktop.
Save 4mitch/25e736d137aa92d27480720b7bb1679e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MS SQL snippets.sql
select t.Name, s.Name, t.Max_Length, t.Precision, t.Scale, t.Is_Nullable
from sys.types t
inner join sys.types s
on s.User_Type_ID = t.System_Type_ID
where t.is_user_defined = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment