Skip to content

Instantly share code, notes, and snippets.

@NKid

NKid/gist:7c9e497a822afd1f0c0f Secret

Last active August 18, 2020 08:42
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 NKid/7c9e497a822afd1f0c0f to your computer and use it in GitHub Desktop.
Save NKid/7c9e497a822afd1f0c0f to your computer and use it in GitHub Desktop.
Download ZIP
顯示資料表全部欄位
Raw
gistfile1.sql
SELECT
c.name
FROM
sys.objects o
INNER JOIN
sys.columns c
ON
c.object_id = o.object_id
AND o.name = '[Table Name]'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment