Code Crafting Diaries
Crafting Code, Creating Wonders
Pages
Home
My Resume
My WordPress Blog
Thursday 24 January 2019
How can I get column names from a table in SQL Server?
You can obtain this information and much, much more by querying the
Information Schema views
.
SELECT
*
FROM
YOURDBNAME
.
INFORMATION_SCHEMA
.
COLUMNS
WHERE
TABLE_NAME
=
N'CUSTOMERS'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment