Catalog Stored Procedures
Catalog Stored Procedures
sp_column_privileges authors
table_qualifier table_owner table_name column_name grantor grantee privilege is_grantable
-------------------------------- -------------------------------- -------------------------------- -------------------------------- -------------------------------- -------------------------------- -------------------------------- ------------
pubs dbo authors address dbo dbo INSERT yes
pubs dbo authors address dbo guest INSERT no
pubs dbo authors address dbo dbo REFERENCES yes
pubs dbo authors address dbo guest REFERENCES no
pubs dbo authors address dbo dbo SELECT yes
pubs dbo authors address dbo dbo UPDATE yes
pubs dbo authors address dbo guest UPDATE no
pubs dbo authors au_fname dbo dbo INSERT yes
pubs dbo authors au_fname dbo guest INSERT no
pubs dbo authors au_fname dbo dbo REFERENCES yes
pubs dbo authors au_fname dbo guest REFERENCES no
pubs dbo authors au_fname dbo dbo SELECT yes
pubs dbo authors au_fname dbo guest SELECT no
pubs dbo authors au_fname dbo dbo UPDATE yes
pubs dbo authors au_fname dbo guest UPDATE no
pubs dbo authors au_id dbo dbo INSERT yes
pubs dbo authors au_id dbo guest INSERT no
pubs dbo authors au_id dbo dbo REFERENCES yes
pubs dbo authors au_id dbo guest REFERENCES no
pubs dbo authors au_id dbo dbo SELECT yes
pubs dbo authors au_id dbo guest SELECT no
pubs dbo authors au_id dbo dbo UPDATE yes
pubs dbo authors au_id dbo guest UPDATE no
pubs dbo authors au_lname dbo dbo INSERT yes
pubs dbo authors au_lname dbo guest INSERT no
pubs dbo authors au_lname dbo dbo REFERENCES yes
pubs dbo authors au_lname dbo guest REFERENCES no
pubs dbo authors au_lname dbo dbo SELECT yes
pubs dbo authors au_lname dbo guest SELECT no
pubs dbo authors au_lname dbo dbo UPDATE yes
pubs dbo authors au_lname dbo guest UPDATE no
pubs dbo authors city dbo dbo INSERT yes
pubs dbo authors city dbo guest INSERT no
pubs dbo authors city dbo dbo REFERENCES yes
pubs dbo authors city dbo guest REFERENCES no
pubs dbo authors city dbo dbo SELECT yes
pubs dbo authors city dbo guest SELECT no
pubs dbo authors city dbo dbo UPDATE yes
pubs dbo authors city dbo guest UPDATE no
pubs dbo authors contract dbo dbo INSERT yes
pubs dbo authors contract dbo guest INSERT no
pubs dbo authors contract dbo dbo REFERENCES yes
pubs dbo authors contract dbo guest REFERENCES no
pubs dbo authors contract dbo dbo SELECT yes
pubs dbo authors contract dbo guest SELECT no
pubs dbo authors contract dbo dbo UPDATE yes
pubs dbo authors contract dbo guest UPDATE no
pubs dbo authors phone dbo dbo INSERT yes
pubs dbo authors phone dbo guest INSERT no
pubs dbo authors phone dbo dbo REFERENCES yes
pubs dbo authors phone dbo guest REFERENCES no
pubs dbo authors phone dbo dbo SELECT yes
pubs dbo authors phone dbo dbo UPDATE yes
pubs dbo authors phone dbo guest UPDATE no
pubs dbo authors state dbo dbo INSERT yes
pubs dbo authors state dbo guest INSERT no
pubs dbo authors state dbo dbo REFERENCES yes
pubs dbo authors state dbo guest REFERENCES no
pubs dbo authors state dbo dbo SELECT yes
pubs dbo authors state dbo guest SELECT no
pubs dbo authors state dbo dbo UPDATE yes
pubs dbo authors state dbo guest UPDATE no
pubs dbo authors zip dbo dbo INSERT yes
pubs dbo authors zip dbo guest INSERT no
pubs dbo authors zip dbo dbo REFERENCES yes
pubs dbo authors zip dbo guest REFERENCES no
pubs dbo authors zip dbo dbo SELECT yes
pubs dbo authors zip dbo guest SELECT no
pubs dbo authors zip dbo dbo UPDATE yes
pubs dbo authors zip dbo guest UPDATE no
(70 row(s) affected)
sp_columns authors
table_qualifier table_owner table_name column_name data_type type_name precision length scale radix nullable remarks ss_data_type colid
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------- -------------------------------- ----------- ----------- ------ ------ -------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ -----
pubs dbo authors au_id 12 id 11 11 (null) (null) 0 (null) 39 1
pubs dbo authors au_lname 12 varchar 40 40 (null) (null) 0 (null) 39 2
pubs dbo authors au_fname 12 varchar 20 20 (null) (null) 0 (null) 39 3
pubs dbo authors phone 1 char 12 12 (null) (null) 0 (null) 47 4
pubs dbo authors address 12 varchar 40 40 (null) (null) 1 (null) 39 5
pubs dbo authors city 12 varchar 20 20 (null) (null) 1 (null) 39 6
pubs dbo authors state 1 char 2 2 (null) (null) 1 (null) 39 7
pubs dbo authors zip 1 char 5 5 (null) (null) 1 (null) 39 8
pubs dbo authors contract -7 bit 1 1 0 2 0 (null) 50 9
sp_databases
database_name database_size remarks
-------------------------------- ------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
insieme 901120 (null)
master 17408 (null)
model 1024 (null)
msdb 4096 (null)
pubs 3072 (null)
tempdb 22528 (null)
(6 row(s) affected)
sp_datatype_info
type_name data_type precision literal_prefix literal_suffix create_params nullable case_sensitive searchable unsigned_attribute money auto_increment local_type_name minimum_scale maximum_scale usertype
-------------------------------- --------- ----------- -------------------------------- -------------------------------- -------------------------------- -------- -------------- ---------- ------------------ ------ -------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- --------
bit -7 1 (null) (null) (null) 0 0 2 (null) 0 (null) bit 0 0 16
tinyint -6 3 (null) (null) (null) 1 0 2 1 0 0 tinyint 0 0 5
tinyint identity -6 3 (null) (null) (null) 0 0 2 1 0 1 tinyint identity 0 0 5
image -4 2147483647 0x (null) (null) 1 0 0 (null) 0 (null) image (null) (null) 20
varbinary -3 255 0x (null) max length 1 0 2 (null) 0 (null) varbinary (null) (null) 4
binary -2 255 0x (null) length 1 0 2 (null) 0 (null) binary (null) (null) 3
timestamp -2 8 0x (null) (null) 0 0 2 (null) 0 (null) timestamp (null) (null) 80
text -1 2147483647 ' ' (null) 1 0 1 (null) 0 (null) text (null) (null) 19
char 1 255 ' ' length 1 0 3 (null) 0 (null) char (null) (null) 1
empid 1 9 ' ' (null) 0 0 3 (null) 0 (null) empid (null) (null) 103
numeric 2 28 (null) (null) precision,scale 1 0 2 0 0 0 numeric 0 28 25
numeric() identity 2 28 (null) (null) precision 0 0 2 0 0 1 numeric() identity 0 0 25
decimal 3 28 (null) (null) precision,scale 1 0 2 0 0 0 decimal 0 28 26
money 3 19 $ (null) (null) 1 0 2 0 1 0 money 4 4 11
smallmoney 3 10 $ (null) (null) 1 0 2 0 1 0 smallmoney 4 4 21
decimal() identity 3 28 (null) (null) precision 0 0 2 0 0 1 decimal() identity 0 0 26
int 4 10 (null) (null) (null) 1 0 2 0 0 0 int 0 0 7
int identity 4 10 (null) (null) (null) 0 0 2 0 0 1 int identity 0 0 7
smallint 5 5 (null) (null) (null) 1 0 2 0 0 0 smallint 0 0 6
smallint identity 5 5 (null) (null) (null) 0 0 2 0 0 1 smallint identity 0 0 6
float 6 15 (null) (null) (null) 1 0 2 0 0 0 float (null) (null) 8
real 7 7 (null) (null) (null) 1 0 2 0 0 0 real (null) (null) 23
datetime 11 23 ' ' (null) 1 0 3 (null) 0 (null) datetime 3 3 12
smalldatetime 11 16 ' ' (null) 1 0 3 (null) 0 (null) smalldatetime 0 0 22
varchar 12 255 ' ' max length 1 0 3 (null) 0 (null) varchar (null) (null) 2
sysname 12 30 ' ' (null) 0 0 3 (null) 0 (null) sysname (null) (null) 18
id 12 11 ' ' (null) 0 0 3 (null) 0 (null) id (null) (null) 101
tid 12 6 ' ' (null) 0 0 3 (null) 0 (null) tid (null) (null) 102
sp_pkeys authors
table_qualifier table_owner table_name column_name key_seq pk_name
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------- ------------------------------
pubs dbo authors au_id 1 UPKCL_auidind
(1 row(s) affected)
sp_server_info
attribute_id attribute_name attribute_value
------------ ------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 DBMS_NAME Microsoft SQL Server
2 DBMS_VER Microsoft SQL Server 6.0 - 6.00.121 (Intel X86)
Jun 7 1995 14:29:25
Copyright (c) 1988-1995 Microsoft Corporation
10 OWNER_TERM owner
11 TABLE_TERM table
12 MAX_OWNER_NAME_LENGTH 30
13 TABLE_LENGTH 30
14 MAX_QUAL_LENGTH 30
15 COLUMN_LENGTH 30
16 IDENTIFIER_CASE MIXED
17 TX_ISOLATION 2
18 COLLATION_SEQ charset=iso_1 sort_order=nocase charset_num=1 sort_order_num=52
19 SAVEPOINT_SUPPORT Y
20 MULTI_RESULT_SETS Y
22 ACCESSIBLE_TABLES Y
100 USERID_LENGTH 30
101 QUALIFIER_TERM database
102 NAMED_TRANSACTIONS Y
103 SPROC_AS_LANGUAGE Y
104 ACCESSIBLE_SPROC Y
105 MAX_INDEX_COLS 16
106 RENAME_TABLE Y
107 RENAME_COLUMN Y
108 DROP_COLUMN N
109 INCREASE_COLUMN_LENGTH N
110 DDL_IN_TRANSACTION N
111 DESCENDING_INDEXES N
112 SP_RENAME Y
113 REMOTE_SPROC Y
500 SYS_SPROC_VERSION 6.00.120
sp_statistics authors
table_qualifier table_owner table_name non_unique index_qualifier index_name type seq_in_index column_name collation cardinality pages filter_condition
-------------------------------- -------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------ ------------ -------------------------------- --------- ----------- ----------- --------------------------------------------------------------------------------------------------------------------------------
pubs dbo authors (null) (null) (null) 0 (null) (null) (null) 23 1 (null)
pubs dbo authors 0 authors UPKCL_auidind 1 1 au_id A 23 1 (null)
pubs dbo authors 1 authors aunmind 3 1 au_lname A (null) (null) (null)
pubs dbo authors 1 authors aunmind 3 2 au_fname A (null) (null) (null)
sp_stored_procedures (eseguito nel database corrente: pubs)
procedure_qualifier procedure_owner procedure_name num_input_params num_output_params num_result_sets remarks procedure_type
------------------------------ ------------------------------ ------------------------------------ ---------------- ----------------- --------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------
pubs dbo byroyalty;1 -1 -1 -1 (null) 2
pubs dbo reptq1;1 -1 -1 -1 (null) 2
pubs dbo reptq2;1 -1 -1 -1 (null) 2
pubs dbo reptq3;1 -1 -1 -1 (null) 2
(4 row(s) affected)
sp_table_privileges authors
table_qualifier table_owner table_name grantor grantee privilege is_grantable
-------------------------------- -------------------------------- -------------------------------- -------------------------------- -------------------------------- -------------------------------- ------------
pubs dbo authors dbo dbo DELETE yes
pubs dbo authors dbo guest DELETE no
pubs dbo authors dbo dbo INSERT yes
pubs dbo authors dbo guest INSERT no
pubs dbo authors dbo dbo REFERENCES yes
pubs dbo authors dbo guest REFERENCES no
pubs dbo authors dbo dbo SELECT yes
pubs dbo authors dbo dbo UPDATE yes
pubs dbo authors dbo guest UPDATE no
(9 row(s) affected)
sp_tables authors
table_qualifier table_owner table_name table_type remarks
------------------------------ ------------------------------ -------------------------------- ------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pubs dbo authors TABLE (null)
Procedure di sistema (System Stored Procedures)
sp_help (eseguito nel database corrente: pubs)
Name Owner Object_type
------------------------------ ------------------------------ ----------------------------------------
titleview dbo view
anagrafica guest user table
authors dbo user table
discounts dbo user table
employee dbo user table
jobs dbo user table
pub_info dbo user table
publishers dbo user table
roysched dbo user table
sales dbo user table
stores dbo user table
titleauthor dbo user table
titles dbo user table
employee_insupd dbo trigger
sysalternates dbo system table
sysarticles dbo system table
syscolumns dbo system table
syscomments dbo system table
sysconstraints dbo system table
sysdepends dbo system table
sysindexes dbo system table
syskeys dbo system table
syslogs dbo system table
sysobjects dbo system table
sysprocedures dbo system table
sysprotects dbo system table
syspublications dbo system table
sysreferences dbo system table
syssegments dbo system table
syssubscriptions dbo system table
systypes dbo system table
sysusers dbo system table
byroyalty dbo stored procedure
reptq1 dbo stored procedure
reptq2 dbo stored procedure
reptq3 dbo stored procedure
DF__authors__phone__03D09CBB dbo default
DF__employee__hire_d__30A34332 dbo default
DF__employee__job_id__2BDE8E15 dbo default
DF__employee__job_lv__2DC6D687 dbo default
DF__employee__pub_id__2EBAFAC0 dbo default
DF__jobs__job_desc__25319086 dbo default
DF__publisher__count__09897611 dbo default
DF__titles__pubdate__0F424F67 dbo default
DF__titles__type__0D5A06F5 dbo default
User_type Storage_type Length Prec Scale Nullable Default_name Rule_name
------------------------------ ------------------------------ ------ ---- ----- -------------------- ------------------------------ ------------------------------
empid char 9 no none none
id varchar 11 no none none
tid varchar 6 no none none
sp_helpdb
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ ----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
insieme 880.00 MB sa 6 Dec 3 1996 no options set
master 17.00 MB sa 1 Jun 7 1995 trunc. log on chkpt.
model 1.00 MB sa 3 Jun 7 1995 no options set
msdb 4.00 MB sa 5 Dec 2 1996 trunc. log on chkpt.
pubs 3.00 MB sa 4 Jun 7 1995 trunc. log on chkpt.
tempdb 22.00 MB sa 2 May 8 1997 select into/bulkcopy