Get Column Names from MS SQL Tables

Query of the day:

SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'tablename'

Gotta luv the MS SQL databases 😛 (in addition: for MySQL a simple DESCRIBE 'tablename' is enough)

Published by Bramus!

Bramus is a frontend web developer from Belgium, working as a Chrome Developer Relations Engineer at Google. From the moment he discovered view-source at the age of 14 (way back in 1997), he fell in love with the web and has been tinkering with it ever since (more …)

Join the Conversation

2 Comments

Leave a comment

Leave a Reply to Klaus Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.