Skip to content

Instantly share code, notes, and snippets.

/DateTime2Check.sql

Created November 30, 2011 00:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/1407385 to your computer and use it in GitHub Desktop.
Save anonymous/1407385 to your computer and use it in GitHub Desktop.
Download ZIP
DateTime2Check.sql
Raw
DateTime2Check.sql
SELECT OBJECT_NAME(c.OBJECT_ID) TableName, c.name ColumnName
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
WHERE t.name = 'DateTime2'
ORDER BY c.OBJECT_ID;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment