TSQL - Don't Forget sp_help!
Posted By : todd sharp Posted At : February 22, 2007 11:37 AM Posted In: SQL
3
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.
Ryan
try dbms_metadata.get_ddl