<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 | 3868 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
TechCrunch Reviews SlideSix
Advanced ColdFusion Ajax Feed Reader
CFSnippets.org
My Wishlist
Model-Glue Cookbook

Calendar

Subscribe

Enter your email address to subscribe to this blog.

search engine optimisation

Archives By Subject

ActionScript (24) [RSS]
AIR (9) [RSS]
Ajax (45) [RSS]
Ant (2) [RSS]
Apache Derby (4) [RSS]
Blogging (23) [RSS]
cfcExplorer (2) [RSS]
cfcFlexplorer (5) [RSS]
cfCodePress (1) [RSS]
CFCs (4) [RSS]
CFEclipse (7) [RSS]
CFeMmys (6) [RSS]
cfImageCropper (6) [RSS]
cfsnippets (15) [RSS]
cfTimeline (7) [RSS]
CFUnited (5) [RSS]
CFUnited 2007 (5) [RSS]
Code Generation (6) [RSS]
ColdFusion (309) [RSS]
Communications (1) [RSS]
CSS (5) [RSS]
Eclipse (4) [RSS]
Excel Hacks (2) [RSS]
Ext (6) [RSS]
Flash Forms (37) [RSS]
Flex (35) [RSS]
Funny Stuff (12) [RSS]
Gaming (8) [RSS]
Google (1) [RSS]
IIS (2) [RSS]
iLearn (2) [RSS]
Java (5) [RSS]
JavaScript (11) [RSS]
jQuery (7) [RSS]
Management (2) [RSS]
Misc (31) [RSS]
Mobile (1) [RSS]
Model-Glue (12) [RSS]
Networking (4) [RSS]
Off Topic (32) [RSS]
OO (5) [RSS]
Personal (35) [RSS]
picViewer (3) [RSS]
pptutils (2) [RSS]
Project Learn (10) [RSS]
Rants (9) [RSS]
Rich Applications (3) [RSS]
Sharepoint (1) [RSS]
SlideSix (49) [RSS]
SQL (37) [RSS]
Usability (5) [RSS]
Vista (4) [RSS]
Web 2.0 (2) [RSS]

Tags

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

Recent Entries

Check Out The New SlideSix
Adrock Set To Rock Out In Cleveland

Recent Comments

Chinese Birth Calendar Accuracy Test
mama to be said: ok so i will be 2 months shy of 18 when i have my baby. this calendar does not technically work for ... [More]

Fixing 'User Profile Service Failed The Logon' on Vista
Mike said: That fix worked although all i did was remove .bak and reset state to 0. User was able to log in to... [More]

Chinese Birth Calendar Accuracy Test
Melissa said: Wrong for my daughter, which it predicted to be a boy... we'll see for #2. Predicts a girl (maybe, f... [More]

Adding Auto Generated Code Downloads to BlogCFC
fweerw said: http://www.ibiblio.org/st... http://www.cambodia.ait.a...... [More]

Check Out The New SlideSix
Todd Sharp said: Thanks for the feedback Ben & Rachel! I'll keep it all in mind as I tweak things over the next ... [More]

my apps

Genesis
Ymap
picViewer
gCal

RSS