System stored procedures and functions


SP_COLUMNS view_employe

— output
TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME PRECISION LENGTH SCALE RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SS_DATA_TYPE
npr dbo VIEW_employe employeid 4 int 10 4 0 10 0 NULL NULL 4 NULL NULL 1 NO 56

npr dbo VIEW_employe employestate 5 smallint 5 2 0 10 1 NULL NULL 5 NULL NULL 2 YES 38


<span style="font-size: x-small; color: #0000ff;">SELECT</span><span style="font-size: x-small;"> </span><span style="font-size: x-small; color: #ff00ff;">@@SERVERNAME</span>

— output
MyServer\AnSQLInstance


Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: