Skip to content

Instantly share code, notes, and snippets.

@ishideo

ishideo/show_columns_sqlserver.sql

Last active November 22, 2018 15:09
Show Gist options
  • Save ishideo/0ca57a8c064f17afac51bba3d4595e21 to your computer and use it in GitHub Desktop.
Save ishideo/0ca57a8c064f17afac51bba3d4595e21 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
show_columns_sqlserver.sql
select
ordinal_position
, column_name
, data_type
, table_name
from
information_schema.columns
where
table_name = dbo.items
order by
ordinal_position
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment