Tables and Columns
What have we learned today? Well, these little gems have helped me out immensely today. I’m going to keep them handy for future use.
List all of the Tables in a Database
SELECT Name
FROM SYSOBJECTS
WHERE XTYPE=’U’
ORDER BY Name
List all of the Columns in a Table
SELECT Column_Name
FROM INFORMATION_SCHEMA.Columns
WHERE TABLE_NAME = ‘<Name>’
No comments yet.
Leave a comment
Plinky- Cold rememdyTo keep symptoms at bay, I take a cocktail of 1) Claritin D 24 hour, 2) Tylenol Daytime cough syrup, & 3) Sudafed.
- Barstow, CA to Wilmington, NCIt's the entirety of I-40. 2,554 miles from end to end. Along the way is the Grand Canyon, Albuquerque NM, Amarillo TX, Oklahoma City, Memphis, Nashville, and the Great Smoky Mountains. I remember seeing this sign: http://www.city-data.com/picfilesc/picc5385.php Inspired me to want to drive it end to end.
- one Halloween I dressed up as the Eye of SauronEye of Sauron no one got it. I had to explain it to everyone. one lady thought I was a vampire and kept talking to me in a Dracula voice. but she also thought the guy dressed up as The Joker was just a party clown and asked why he wasn't wearing big clown shoes.
- my pantry is filled with staplesdry beans pasta rice can of stewed tomatoes
- Cold rememdy
- what I’m listening to…
- The Beatles - Abbey Road it’s peculiar that I grew up... October 28, 2009
- Ingrid Michaelson - Everybody September 29, 2009
- Interpol - Turn on the Bright Lights September 3, 2009
- My Morning Jacket - Evil Urges. August 18, 2009
- Wilco - Sky Blue Sky I didn’t like ‘A Ghost Is... July 10, 2009
- Paolo Nutini - Sunny Side Up It’s pretty good mood music.... June 24, 2009
- Sufjan Stevens - Illnoise Kind of a kooky album. Jury is out, I... June 1, 2009
- Red Hot Chili Peppers - Stadium Arcadium As I drove from work... May 21, 2009
- Pink Floyd - Dark Side of the Moon I needed some music at work... May 19, 2009
- Nickel Creek - Why Should the Fire Die I had my iPhone on... May 19, 2009
-
Photos
More Photos - Random Quotes
- Jean Giraudoux"Only the mediocre are always at their best."
- Benjamin Spock"You know more than you think you do."
- Robert Half"Not admitting a mistake is a bigger mistake."
- David Sarnoff"Nobody can be successful if he doesn't love his work, love his job."
- Jean Giraudoux
