<cfsilence>

TSQL - Don't Forget sp_help!

Posted At : February 22, 2007 12:37 PM | Posted By : todd sharp
Related Categories: SQL

Such a simple thing, but since I always forget that this little beauty exists I thought I'd blog for anyone who also forgets (or doesn't know about) sp_help. Check the docs for specifics, but essentially sp_help will give you metadata about an object (table, UDF, etc). Column names, datatypes, etc. Quick and dirty, just the way I like it.

Print |

Send |

Linking Blogs | 3113 Views

Comments

[Add Comment]

Todd, thats awesome! I did not know of that SP! Thanks for the heads up.

Ryan

# Posted By Ryan Everhart | 2/22/07 2:24 PM

that's smart. anybody know if there is anything similar in oracle? cheers

# Posted By dc | 2/22/07 4:45 PM

6yeah, In Oracle it's dbms_Metada

try dbms_metadata.get_ddl

# Posted By Rob.dominguez | 7/16/07 2:47 PM

[Add Comment]

What's New

SlideSix.com
Advanced ColdFusion Ajax Feed Reader
CFSnippets.org
PowerPoint To HTML
PPTUtils Demo
2007 CFeMmy Winners
Be My Secret Santa
Model-Glue Cookbook
Bored? Try Word Art!

Calendar

Subscribe

Enter your email address to subscribe to this blog.

Archives By Subject

Actionscript (22) [RSS]
AIR (2) [RSS]
Ajax (42) [RSS]
Ant (2) [RSS]
Apache Derby (4) [RSS]
Blogging (23) [RSS]
cfcExplorer (2) [RSS]
cfcFlexplorer (5) [RSS]
cfCodePress (1) [RSS]
CFCs (4) [RSS]
CFDdlUtils (1) [RSS]
CFEclipse (7) [RSS]
CFeMmys (4) [RSS]
cfImageCropper (6) [RSS]
cfResizer (1) [RSS]
cfsnippets (15) [RSS]
cfTimeline (7) [RSS]
CFUnited 2007 (5) [RSS]
Code Generation (6) [RSS]
ColdFusion (288) [RSS]
CSS (3) [RSS]
Eclipse (4) [RSS]
Excel Hacks (2) [RSS]
Excel Tips (1) [RSS]
Ext (5) [RSS]
Flash (1) [RSS]
Flash Forms (37) [RSS]
Flex (24) [RSS]
Funny Stuff (10) [RSS]
Gadgets and Technology (2) [RSS]
Gaming (8) [RSS]
IIS (2) [RSS]
iLearn (2) [RSS]
InstantSpot (3) [RSS]
Java (4) [RSS]
JavaScript (6) [RSS]
jQuery (5) [RSS]
JSON (1) [RSS]
Junk (1) [RSS]
Mach-ii (2) [RSS]
Management (2) [RSS]
Misc (29) [RSS]
Mobile (1) [RSS]
Model-Glue (12) [RSS]
Off Topic (30) [RSS]
OO (5) [RSS]
Personal (31) [RSS]
picViewer (3) [RSS]
pptutils (2) [RSS]
Project Learn (10) [RSS]
Rants (9) [RSS]
Rich Applications (2) [RSS]
Sharepoint (1) [RSS]
SlideSix (23) [RSS]
SQL (37) [RSS]
Usability (3) [RSS]
Vista (3) [RSS]
Web 2.0 (2) [RSS]
XML (1) [RSS]

Tags

actionscript ajax blogging cfsnippets coldfusion flash forms flex funny stuff misc model-glue off topic personal project learn slidesix sql

Recent Entries

Create A CF Style UUID In Flex
New Flex Viewer Widget Launched

Recent Comments

Editing A Query In A SQL Server DTS Package
JD said: Thanks for your post. Never unlike Microsoft to hide stuff in the hardest part time find. [More]

Mashing Spry Effects With CF8 Ajax Goodness
Mark Pitts said: I have had moderate success implementing Spry Accordian. Sadly the part that does is not working wil... [More]

Chinese Birth Calendar Accuracy Test
Toni Lehman said: This calendar was accurate for both my daughters and 4 grandchildren. I tried it for 11 of my other ... [More]

Virtual Memory - Am I The Last To Know?
Larry Miller said: The authors friend was right. Windows virtual memory system was designed by experts and they fully u... [More]

Using A PlayStation 2 HDD In Your PC
Alacres said: Thanks so much for the guide man! I did have a more specific question though, since I didn't see it ... [More]

my apps

Genesis
Ymap
picViewer
gCal

RSS