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 Freelance Web Developer from Belgium. 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

Your email address will not be published. Required fields are marked *

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