Daniel Hutmacher has released a new tool:
I designed my sp_ctrl3 procedure from the ground up to be a development tool that I can install on any dev environment that I use regularly. I wanted a detailed overview of a specific database object as well as copy-paste-friendly T-SQL code. For instance,
-
No “length” column on an int column
-
Proper scale/precision values on datatypes
-
“NULL” or “NOT NULL” instead of “yes” or “no”
-
Identity column syntax
-
“nvarchar(50)” instead of “nvarchar”, “100”
-
Column defaults
-
Complete index definitions
-
GRANT/DENY permission statements
-
The object_id of the object in sys.objects
If you use sp_help a lot, this looks like a good supplement.