List of Sybase Tables ------------------------------------------------------------------------------ SQL Server: firstsun Version: Adaptive Server Enterprise/12.5.0.1/SWR 10235 ESD#1/P/Sun_svr4/OS 5.8/rel12501/1778/32-bit/FBO/Tue May 7 03:15:10 2002 Database: master Sybase User: sa UNIX User: ceccareb Owner Pattern: Table Pattern: Order: Alphabetical Time: Sun Sep 29 08:20:32 2002 ......................................................... Trigger Attribute Legend ......................................................... Attributes: s: There is a select trigger on the table u: There is an update trigger on the table d: There is a delete trigger on the table i: There is an insert trigger on the table ......................................................... ......................................................... Index Attribute Legend ......................................................... Attributes: u: unique index c: clustered index p: index created by a primary key constraint k: index created by a unique constraint r: index takes part of referential integrity constraint g: index name is a generated constraint name a: index allows duplicate rows i: index ignores duplicate rows d: index ignores duplicate keys s: index created with the sorted data option l: large I/Os enabled m: MRU cache strategy enabled B: index suspected to be bad ......................................................... ......................................................... Referential Integrity Constraints Attribute Legend ......................................................... Attributes: g: Sybase generated the constraint name ......................................................... Column Definitions ------------------------------------------------------------------------------ 1. dbo.ijdbc_function_escapes # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. escape_name varchar 40 40 2. map_string varchar 40 40 dbo.ijdbc_function_escapes has no indexes. Permissions on dbo.ijdbc_function_escapes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 2. dbo.jdbc_function_escapes # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. escape_name varchar 40 40 2. map_string varchar 40 40 dbo.jdbc_function_escapes has no indexes. Permissions on dbo.jdbc_function_escapes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 3. dbo.spt_ijdbc_conversion # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. datatype int 4 4 2. conversion char 20 20 dbo.spt_ijdbc_conversion has no indexes. Permissions on dbo.spt_ijdbc_conversion: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 4. dbo.spt_ijdbc_mda # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. mdinfo varchar 30 30 2. querytype tinyint 1 1 3. pre_query varchar 600 600 Yes 4. query varchar 255 255 Yes 5. post_query varchar 255 255 Yes 6. mdaver_start tinyint 1 1 7. mdaver_end tinyint 1 1 8. srvver_start int 4 4 9. srvver_end int 4 4 Indexes for dbo.spt_ijdbc_mda: Name Attributes Segment Columns ---------------------------------------------------- spt_ijdbc_mda_ind (u) default mdinfo, mdaver_end, srvver_end Permissions on dbo.spt_ijdbc_mda: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................... 5. dbo.spt_ijdbc_table_types # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. TABLE_TYPE char 15 15 dbo.spt_ijdbc_table_types has no indexes. Permissions on dbo.spt_ijdbc_table_types: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 6. dbo.spt_jdbc_conversion # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. datatype int 4 4 2. conversion char 20 20 dbo.spt_jdbc_conversion has no indexes. Permissions on dbo.spt_jdbc_conversion: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 7. dbo.spt_jdbc_table_types # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. TABLE_TYPE char 15 15 dbo.spt_jdbc_table_types has no indexes. Permissions on dbo.spt_jdbc_table_types: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 8. dbo.spt_jtext # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ......................................................................... 1. mdinfo varchar 30 30 2. value text 16 16 Indexes for dbo.spt_jtext: Name Attributes Segment Columns -------------------------------------------------------------- spt_jtext_mdinfo_5280018812 (ukg) default mdinfo Permissions on dbo.spt_jtext: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ......................................................................... 9. dbo.spt_limit_types # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. name char 30 30 2. id smallint 2 2 3. enforced tinyint 1 1 4. object_type smallint 2 2 5. scope smallint 2 2 6. units char 60 60 dbo.spt_limit_types has no indexes. Permissions on dbo.spt_limit_types: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 10. dbo.spt_mda # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. mdinfo varchar 30 30 2. querytype tinyint 1 1 3. query varchar 255 255 Yes 4. mdaver_start tinyint 1 1 5. mdaver_end tinyint 1 1 6. srvver_start int 4 4 7. srvver_end int 4 4 Indexes for dbo.spt_mda: Name Attributes Segment Columns ---------------------------------------------- spt_mda_ind (u) default mdinfo, mdaver_end, srvver_end Permissions on dbo.spt_mda: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................... 11. dbo.spt_monitor # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ................................................................................ 1. lastrun datetime 8 8 2. cpu_busy int 4 4 3. io_busy int 4 4 4. idle int 4 4 5. pack_received int 4 4 6. pack_sent int 4 4 7. connections int 4 4 8. pack_errors int 4 4 9. total_read int 4 4 10. total_write int 4 4 11. total_errors int 4 4 dbo.spt_monitor has no indexes. Permissions on dbo.spt_monitor: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ................................................................................ 12. dbo.spt_values # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ......................................................................... 1. name varchar 28 28 Yes 2. number int 4 4 3. type char 2 2 4. ansi_w tinyint 1 1 Yes 5. low int 4 4 Yes 6. high int 4 4 Yes 7. msgnum int 4 4 Yes Indexes for dbo.spt_values: Name Attributes Segment Columns -------------------------------------------------- spt_valuesclust (c) system number, type Permissions on dbo.spt_values: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ......................................................................... 13. dbo.syblicenseslog # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. status smallint 2 2 2. logdate datetime 8 8 3. maxlicenses int 4 4 dbo.syblicenseslog has no indexes. .............................................................................. 14. dbo.sysalternates # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. suid int 4 4 2. altsuid int 4 4 Indexes for dbo.sysalternates: Name Attributes Segment Columns ------------------------------------------------ sysalternates (uc) system suid sp_primarykey defined for dbo.sysalternates: Column 1: suid Outgoing sp_foreignkeys from dbo.sysalternates: 1. sp_foreignkey references table master.dbo.sysusers Column suid to sysusers.suid Permissions on dbo.sysalternates: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 15. dbo.sysattributes # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. class smallint 2 2 2. attribute smallint 2 2 3. object_type char 2 2 4. object_cinfo varchar 30 30 Yes 5. object int 4 4 Yes 6. object_info1 int 4 4 Yes 7. object_info2 int 4 4 Yes 8. object_info3 int 4 4 Yes 9. int_value int 4 4 Yes 10. char_value varchar 255 255 Yes 11. text_value text 16 16 Yes 12. image_value image 16 16 Yes 13. comments varchar 255 255 Yes Indexes for dbo.sysattributes: Name Attributes Segment Columns -------------------------------------------------- csysattributes (uc) system class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo ncsysattributes system object_type, object, object_info1, object_info2, object_info3, object_cinfo Permissions on dbo.sysattributes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................... 16. dbo.syscertificates # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. certhash binary 20 20 2. validfrom datetime 8 8 3. validto datetime 8 8 4. common_name sysname 30 30 5. type smallint 2 2 6. suid int 4 4 Indexes for dbo.syscertificates: Name Attributes Segment Columns --------------------------------------------------- csyscertificates (u) system certhash .............................................................................. 17. dbo.syscharsets # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. type smallint 2 2 2. id tinyint 1 1 3. csid tinyint 1 1 4. status smallint 2 2 5. name varchar 30 30 6. description varchar 255 255 7. definition image 16 16 8. sortfile varchar 30 30 Yes Indexes for dbo.syscharsets: Name Attributes Segment Columns ------------------------------------------------ csyscharsets (uc) default id, csid ncsyscharsets (u) default name Permissions on dbo.syscharsets: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 18. dbo.syscolumns # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. id int 4 4 2. number smallint 2 2 3. colid smallint 2 2 4. status tinyint 1 1 5. type tinyint 1 1 6. length int 4 4 7. offset smallint 2 2 8. usertype smallint 2 2 9. cdefault int 4 4 10. domain int 4 4 11. name sysname 30 30 12. printfmt varchar 255 255 Yes 13. prec tinyint 1 1 Yes 14. scale tinyint 1 1 Yes 15. remote_type int 4 4 Yes 16. remote_name varchar 30 30 Yes 17. xstatus int 4 4 Yes 18. xtype int 4 4 Yes 19. xdbid int 4 4 Yes 20. accessrule int 4 4 Yes 21. status2 int 4 4 Yes Indexes for dbo.syscolumns: Name Attributes Segment Columns --------------------------------------------- syscolumns (uc) system id, number, colid sp_primarykey defined for dbo.syscolumns: Column 1: id Column 2: number Column 3: colid Outgoing sp_commonkeys from dbo.syscolumns: 1. sp_commonkey references table master.dbo.syscomments Column id to syscomments.id 2. sp_commonkey references table master.dbo.syskeys Column id to syskeys.key1 3. sp_commonkey references table master.dbo.syskeys Column id to syskeys.depkey1 4. sp_commonkey references table master.dbo.sysobjects Column id to sysobjects.id 5. sp_commonkey references table master.dbo.systypes Column type to systypes.type 6. sp_commonkey references table master.dbo.systypes Column usertype to systypes.usertype 7. sp_commonkey references table master.dbo.systypes Column domain to systypes.domain 8. sp_commonkey references table master.dbo.systypes Column cdefault to systypes.tdefault Permissions on dbo.syscolumns: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 19. dbo.syscomments # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ........................................................................... 1. id int 4 4 2. number smallint 2 2 3. colid smallint 2 2 4. texttype smallint 2 2 5. language smallint 2 2 6. text varchar 255 255 Yes 7. colid2 smallint 2 2 8. status smallint 2 2 Yes Indexes for dbo.syscomments: Name Attributes Segment Columns ---------------------------------------------- syscomments (uc) default id, number, colid2, colid, texttype sp_primarykey defined for dbo.syscomments: Column 1: id Column 2: number Column 3: colid2 Column 4: colid Column 5: texttype Outgoing sp_commonkeys from dbo.syscomments: 1. sp_commonkey references table master.dbo.sysobjects Column id to sysobjects.id sp_commonkeys coming into dbo.syscomments from other tables: 1. sp_commonkey from table master.dbo.syscolumns syscolumns.id to column id Permissions on dbo.syscomments: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ........................................................................... 20. dbo.sysconfigures # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. config smallint 2 2 2. value int 4 4 3. comment varchar 255 255 4. status int 4 4 5. name varchar 80 80 Yes 6. parent smallint 2 2 Yes 7. value2 varchar 255 255 Yes 8. value3 int 4 4 Yes 9. value4 int 4 4 Yes Indexes for dbo.sysconfigures: Name Attributes Segment Columns --------------------------------------------------- csysconfigures (uc) default name, parent, config nc1sysconfigures default parent, config nc2sysconfigures default config sp_primarykey defined for dbo.sysconfigures: Column 1: config sp_commonkeys coming into dbo.sysconfigures from other tables: 1. sp_commonkey from table master.dbo.syscurconfigs syscurconfigs.config to column config Permissions on dbo.sysconfigures: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 21. dbo.sysconstraints # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ........................................................................... 1. colid smallint 2 2 2. constrid int 4 4 3. tableid int 4 4 4. error int 4 4 5. status int 4 4 6. spare2 int 4 4 Indexes for dbo.sysconstraints: Name Attributes Segment Columns --------------------------------------------------- csysconstraints (c) system tableid, colid ncsysconstraints (u) system constrid Permissions on dbo.sysconstraints: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ........................................................................... 22. dbo.syscurconfigs # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ................................................................................ 1. config smallint 2 2 2. value int 4 4 3. comment varchar 255 255 4. status int 4 4 5. value2 varchar 255 255 Yes 6. defvalue varchar 255 255 Yes 7. minimum_value int 4 4 Yes 8. maximum_value int 4 4 Yes 9. memory_used int 4 4 Yes 10. display_level int 4 4 Yes 11. datatype int 4 4 Yes 12. message_num int 4 4 Yes 13. apf_percent int 4 4 Yes 14. unit varchar 20 20 Yes 15. type varchar 10 10 Yes dbo.syscurconfigs has no indexes. Outgoing sp_commonkeys from dbo.syscurconfigs: 1. sp_commonkey references table master.dbo.sysconfigures Column config to sysconfigures.config Permissions on dbo.syscurconfigs: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ................................................................................ 23. dbo.sysdatabases # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .................................................................................. 1. name sysname 30 30 2. dbid smallint 2 2 3. suid int 4 4 4. status smallint 2 2 5. version smallint 2 2 6. logptr int 4 4 7. crdate datetime 8 8 8. dumptrdate datetime 8 8 9. status2 smallint 2 2 Yes 10. audflags int 4 4 Yes 11. deftabaud int 4 4 Yes 12. defvwaud int 4 4 Yes 13. defpraud int 4 4 Yes 14. def_remote_type smallint 2 2 Yes 15. def_remote_loc varchar 255 255 Yes 16. status3 int 4 4 Yes 17. status4 int 4 4 Yes Indexes for dbo.sysdatabases: Name Attributes Segment Columns ------------------------------------------------- sysdatabases (uc) system name ncsysdatabases (u) system dbid sp_primarykey defined for dbo.sysdatabases: Column 1: name Outgoing sp_commonkeys from dbo.sysdatabases: 1. sp_commonkey references table master.dbo.syslocks Column dbid to syslocks.dbid 2. sp_commonkey references table master.dbo.syslogins Column suid to syslogins.suid 3. sp_commonkey references table master.dbo.sysprocesses Column dbid to sysprocesses.dbid 4. sp_commonkey references table master.dbo.sysusages Column dbid to sysusages.dbid Permissions on dbo.sysdatabases: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x0F0FFE dbo 2. sso_role grant select 0x01 dbo .................................................................................. 24. dbo.sysdepends # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................ 1. id int 4 4 2. number smallint 2 2 3. depid int 4 4 4. depnumber smallint 2 2 5. status smallint 2 2 6. selall bit 1 1 7. resultobj bit 1 1 8. readobj bit 1 1 Indexes for dbo.sysdepends: Name Attributes Segment Columns --------------------------------------------- sysdepends (ucd) system id, number, depid, depnumber sp_primarykey defined for dbo.sysdepends: Column 1: id Column 2: number Column 3: depid Column 4: depnumber Outgoing sp_commonkeys from dbo.sysdepends: 1. sp_commonkey references table master.dbo.sysobjects Column id to sysobjects.id Permissions on dbo.sysdepends: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................ 25. dbo.sysdevices # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. low int 4 4 2. high int 4 4 3. status smallint 2 2 4. cntrltype smallint 2 2 5. name sysname 30 30 6. phyname varchar 127 127 7. mirrorname varchar 127 127 Yes Indexes for dbo.sysdevices: Name Attributes Segment Columns --------------------------------------------- sysdevices (uc) system name sp_primarykey defined for dbo.sysdevices: Column 1: name Permissions on dbo.sysdevices: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 26. dbo.sysengines # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. engine smallint 2 2 2. osprocid int 4 4 3. osprocname char 32 32 4. status char 12 12 5. affinitied int 4 4 6. cur_kpid int 4 4 7. last_kpid int 4 4 8. idle_1 tinyint 1 1 9. idle_2 tinyint 1 1 10. idle_3 tinyint 1 1 11. idle_4 tinyint 1 1 12. starttime datetime 8 8 dbo.sysengines has no indexes. ............................................................................. 27. dbo.sysindexes # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .................................................................................. 1. name sysname 30 30 Yes 2. id int 4 4 3. indid smallint 2 2 4. doampg int 4 4 5. ioampg int 4 4 6. oampgtrips int 4 4 7. status2 smallint 2 2 8. ipgtrips int 4 4 9. first int 4 4 10. root int 4 4 11. distribution int 4 4 12. usagecnt smallint 2 2 13. segment smallint 2 2 14. status smallint 2 2 15. maxrowsperpage smallint 2 2 16. minlen smallint 2 2 17. maxlen smallint 2 2 18. maxirow smallint 2 2 19. keycnt smallint 2 2 20. keys1 varbinary 255 255 Yes 21. keys2 varbinary 255 255 Yes 22. soid tinyint 1 1 23. csid tinyint 1 1 24. base_partition int 4 4 Yes 25. fill_factor smallint 2 2 Yes 26. res_page_gap smallint 2 2 Yes 27. exp_rowsize smallint 2 2 Yes 28. keys3 varbinary 255 255 Yes 29. identitygap int 4 4 Yes 30. crdate datetime 8 8 Yes Indexes for dbo.sysindexes: Name Attributes Segment Columns --------------------------------------------- sysindexes (uc) system id, indid sp_primarykey defined for dbo.sysindexes: Column 1: id Column 2: indid Outgoing sp_commonkeys from dbo.sysindexes: 1. sp_commonkey references table master.dbo.sysobjects Column id to sysobjects.id 2. sp_commonkey references table master.dbo.syssegments Column segment to syssegments.segment Permissions on dbo.sysindexes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .................................................................................. 28. dbo.sysjars # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. jstatus smallint 2 2 2. jid int 4 4 3. jname varchar 30 30 Yes 4. jbinary image 16 16 Yes Indexes for dbo.sysjars: Name Attributes Segment Columns -------------------------------------------- csysjars (u) system jid ncsysjars (u) system jname Permissions on dbo.sysjars: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 29. dbo.syskeys # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. id int 4 4 2. type smallint 2 2 3. depid int 4 4 Yes 4. keycnt int 4 4 Yes 5. size int 4 4 Yes 6. key1 smallint 2 2 Yes 7. key2 smallint 2 2 Yes 8. key3 smallint 2 2 Yes 9. key4 smallint 2 2 Yes 10. key5 smallint 2 2 Yes 11. key6 smallint 2 2 Yes 12. key7 smallint 2 2 Yes 13. key8 smallint 2 2 Yes 14. depkey1 smallint 2 2 Yes 15. depkey2 smallint 2 2 Yes 16. depkey3 smallint 2 2 Yes 17. depkey4 smallint 2 2 Yes 18. depkey5 smallint 2 2 Yes 19. depkey6 smallint 2 2 Yes 20. depkey7 smallint 2 2 Yes 21. depkey8 smallint 2 2 Yes 22. spare1 smallint 2 2 Indexes for dbo.syskeys: Name Attributes Segment Columns ------------------------------------------ syskeys (c) system id sp_primarykey defined for dbo.syskeys: Column 1: id Outgoing sp_foreignkeys from dbo.syskeys: 1. sp_foreignkey references table master.dbo.sysobjects Column id to sysobjects.id Outgoing sp_commonkeys from dbo.syskeys: 1. sp_commonkey references table master.dbo.sysobjects Column depid to sysobjects.id sp_commonkeys coming into dbo.syskeys from other tables: 1. sp_commonkey from table master.dbo.syscolumns syscolumns.id to column key1 2. sp_commonkey from table master.dbo.syscolumns syscolumns.id to column depkey1 Permissions on dbo.syskeys: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 30. dbo.syslanguages # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. langid smallint 2 2 2. dateformat char 3 3 3. datefirst tinyint 1 1 4. upgrade int 4 4 5. name varchar 30 30 6. alias varchar 30 30 Yes 7. months varchar 251 251 8. shortmonths varchar 119 119 9. days varchar 216 216 Indexes for dbo.syslanguages: Name Attributes Segment Columns -------------------------------------------------- csyslanguages (uc) default langid nc1syslanguages (u) default name nc2syslanguages (u) default alias Permissions on dbo.syslanguages: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 31. dbo.syslisteners # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. net_type char 32 32 2. address_info char 255 255 dbo.syslisteners has no indexes. ............................................................................... 32. dbo.syslocks # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. id int 4 4 2. dbid smallint 2 2 3. page int 4 4 4. type smallint 2 2 5. spid smallint 2 2 6. class varchar 30 30 Yes 7. fid smallint 2 2 Yes 8. context tinyint 1 1 Yes 9. row smallint 2 2 Yes 10. loid int 4 4 Yes dbo.syslocks has no indexes. Outgoing sp_commonkeys from dbo.syslocks: 1. sp_commonkey references table master.dbo.sysprocesses Column spid to sysprocesses.spid sp_commonkeys coming into dbo.syslocks from other tables: 1. sp_commonkey from table master.dbo.sysdatabases sysdatabases.dbid to column dbid Permissions on dbo.syslocks: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 33. dbo.sysloginroles # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ......................................................................... 1. suid int 4 4 2. srid int 4 4 3. status smallint 2 2 Indexes for dbo.sysloginroles: Name Attributes Segment Columns ------------------------------------------------- csysloginroles (c) system suid ......................................................................... 34. dbo.syslogins # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. suid int 4 4 2. status smallint 2 2 3. accdate datetime 8 8 4. totcpu int 4 4 5. totio int 4 4 6. spacelimit int 4 4 7. timelimit int 4 4 8. resultlimit int 4 4 9. dbname sysname 30 30 Yes 10. name sysname 30 30 11. password varbinary 30 30 Yes 12. language varchar 30 30 Yes 13. pwdate datetimn 8 8 Yes 14. audflags int 4 4 Yes 15. fullname varchar 30 30 Yes 16. srvname varchar 30 30 Yes 17. logincount smallint 2 2 Yes 18. procid int 4 4 Yes Indexes for dbo.syslogins: Name Attributes Segment Columns ---------------------------------------------- syslogins (uc) system suid ncsyslogins (u) system name sp_primarykey defined for dbo.syslogins: Column 1: suid Outgoing sp_commonkeys from dbo.syslogins: 1. sp_commonkey references table master.dbo.sysprocesses Column suid to sysprocesses.suid sp_commonkeys coming into dbo.syslogins from other tables: 1. sp_commonkey from table master.dbo.sysdatabases sysdatabases.suid to column suid Permissions on dbo.syslogins: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x07B7FE dbo 2. sso_role grant select 0x01 dbo ............................................................................... 35. dbo.syslogs # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ......................................................................... 1. xactid binary 6 6 2. op tinyint 1 1 dbo.syslogs has no indexes. Permissions on dbo.syslogs: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ......................................................................... 36. dbo.syslogshold # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. dbid smallint 2 2 2. reserved int 4 4 3. spid smallint 2 2 4. page int 4 4 5. xactid binary 6 6 6. masterxactid binary 6 6 7. starttime datetime 8 8 8. name char 67 67 9. xloid int 4 4 Yes dbo.syslogshold has no indexes. ............................................................................... 37. dbo.sysmessages # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. error int 4 4 2. severity smallint 2 2 3. dlevel smallint 2 2 4. description varchar 1024 1024 5. langid smallint 2 2 Yes 6. sqlstate varchar 5 5 Yes Indexes for dbo.sysmessages: Name Attributes Segment Columns ------------------------------------------------ sysmessages (c) system error, dlevel ncsysmessages (u) default error, dlevel, langid sp_primarykey defined for dbo.sysmessages: Column 1: error Column 2: dlevel Permissions on dbo.sysmessages: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 38. dbo.sysmonitors # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. field_name char 79 79 2. group_name char 25 25 3. field_id smallint 2 2 4. value int 4 4 5. description varchar 255 255 Yes dbo.sysmonitors has no indexes. .............................................................................. 39. dbo.sysobjects # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................ 1. name sysname 30 30 2. id int 4 4 3. uid int 4 4 4. type char 2 2 5. userstat smallint 2 2 6. sysstat smallint 2 2 7. indexdel smallint 2 2 8. schemacnt smallint 2 2 9. sysstat2 int 4 4 10. crdate datetime 8 8 11. expdate datetime 8 8 12. deltrig int 4 4 13. instrig int 4 4 14. updtrig int 4 4 15. seltrig int 4 4 16. ckfirst int 4 4 17. cache smallint 2 2 18. audflags int 4 4 Yes 19. objspare int 4 4 20. versionts binary 12 12 Yes 21. loginame varchar 30 30 Yes Indexes for dbo.sysobjects: Name Attributes Segment Columns ----------------------------------------------- sysobjects (uc) system id ncsysobjects (u) system name, uid sp_primarykey defined for dbo.sysobjects: Column 1: id sp_foreignkeys coming into dbo.sysobjects from other tables: 1. sp_foreignkey from table master.dbo.syskeys syskeys.id to column id Outgoing sp_commonkeys from dbo.sysobjects: 1. sp_commonkey references table master.dbo.sysprocedures Column id to sysprocedures.id 2. sp_commonkey references table master.dbo.sysprotects Column id to sysprotects.id 3. sp_commonkey references table master.dbo.sysusers Column uid to sysusers.uid sp_commonkeys coming into dbo.sysobjects from other tables: 1. sp_commonkey from table master.dbo.sysindexes sysindexes.id to column id 2. sp_commonkey from table master.dbo.syscolumns syscolumns.id to column id 3. sp_commonkey from table master.dbo.syscomments syscomments.id to column id 4. sp_commonkey from table master.dbo.sysdepends sysdepends.id to column id 5. sp_commonkey from table master.dbo.syskeys syskeys.depid to column id Permissions on dbo.sysobjects: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x3BFFFE dbo 2. sso_role grant select 0x01 dbo ............................................................................ 40. dbo.syspartitions # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. state smallint 2 2 2. id int 4 4 3. partitionid int 4 4 4. firstpage int 4 4 5. controlpage int 4 4 6. spare binary 32 32 Indexes for dbo.syspartitions: Name Attributes Segment Columns ------------------------------------------------- csyspartitions (uc) system id, partitionid .............................................................................. 41. dbo.sysprocedures # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ........................................................................... 1. type smallint 2 2 2. id int 4 4 3. sequence int 4 4 4. status smallint 2 2 5. number smallint 2 2 6. version int 4 4 Yes Indexes for dbo.sysprocedures: Name Attributes Segment Columns ------------------------------------------------ sysprocedures (uc) system id, number, type, sequence sp_primarykey defined for dbo.sysprocedures: Column 1: id Column 2: number Column 3: type Column 4: sequence sp_commonkeys coming into dbo.sysprocedures from other tables: 1. sp_commonkey from table master.dbo.sysobjects sysobjects.id to column id Permissions on dbo.sysprocedures: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ........................................................................... 42. dbo.sysprocesses # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ................................................................................... 1. spid smallint 2 2 2. kpid int 4 4 3. enginenum int 4 4 4. status char 12 12 5. suid int 4 4 6. hostname char 10 10 7. program_name char 16 16 8. hostprocess char 8 8 9. cmd char 16 16 10. cpu int 4 4 11. physical_io int 4 4 12. memusage int 4 4 13. blocked smallint 2 2 14. dbid smallint 2 2 15. uid int 4 4 16. gid int 4 4 17. tran_name varchar 64 64 Yes 18. time_blocked int 4 4 Yes 19. network_pktsz int 4 4 Yes 20. fid smallint 2 2 Yes 21. execlass varchar 30 30 Yes 22. priority varchar 10 10 Yes 23. affinity varchar 30 30 Yes 24. id int 4 4 Yes 25. stmtnum int 4 4 Yes 26. linenum int 4 4 Yes 27. origsuid int 4 4 Yes 28. block_xloid int 4 4 Yes 29. clientname varchar 30 30 Yes 30. clienthostname varchar 30 30 Yes 31. clientapplname varchar 30 30 Yes 32. sys_id smallint 2 2 Yes 33. ses_id int 4 4 Yes 34. loggedindatetime datetime 8 8 Yes 35. ipaddr varchar 15 15 Yes dbo.sysprocesses has no indexes. sp_commonkeys coming into dbo.sysprocesses from other tables: 1. sp_commonkey from table master.dbo.sysdatabases sysdatabases.dbid to column dbid 2. sp_commonkey from table master.dbo.syslogins syslogins.suid to column suid 3. sp_commonkey from table master.dbo.syslocks syslocks.spid to column spid Permissions on dbo.sysprocesses: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ................................................................................... 43. dbo.sysprotects # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. id int 4 4 2. uid int 4 4 3. action smallint 2 2 4. protecttype tinyint 1 1 5. columns varbinary 133 133 Yes 6. grantor int 4 4 Yes Indexes for dbo.sysprotects: Name Attributes Segment Columns ---------------------------------------------- sysprotects (uc) system id, action, grantor, uid, protecttype sp_primarykey defined for dbo.sysprotects: Column 1: id Column 2: uid Column 3: action Outgoing sp_commonkeys from dbo.sysprotects: 1. sp_commonkey references table master.dbo.sysusers Column uid to sysusers.uid sp_commonkeys coming into dbo.sysprotects from other tables: 1. sp_commonkey from table master.dbo.sysobjects sysobjects.id to column id Permissions on dbo.sysprotects: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................... 44. dbo.sysqueryplans # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ........................................................................... 1. uid int 4 4 2. gid int 4 4 3. hashkey int 4 4 4. id int 4 4 5. type smallint 2 2 6. sequence smallint 2 2 7. status int 4 4 Yes 8. text varchar 255 255 Yes Indexes for dbo.sysqueryplans: Name Attributes Segment Columns -------------------------------------------------- csysqueryplans (u) system uid, gid, hashkey, id, type, sequence ncsysqueryplans (u) system id, type, sequence ........................................................................... 45. dbo.sysreferences # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. indexid smallint 2 2 2. constrid int 4 4 3. tableid int 4 4 4. reftabid int 4 4 5. keycnt smallint 2 2 6. status smallint 2 2 7. frgndbid smallint 2 2 8. pmrydbid smallint 2 2 9. spare2 int 4 4 10. fokey1 smallint 2 2 11. fokey2 smallint 2 2 12. fokey3 smallint 2 2 13. fokey4 smallint 2 2 14. fokey5 smallint 2 2 15. fokey6 smallint 2 2 16. fokey7 smallint 2 2 17. fokey8 smallint 2 2 18. fokey9 smallint 2 2 19. fokey10 smallint 2 2 20. fokey11 smallint 2 2 21. fokey12 smallint 2 2 22. fokey13 smallint 2 2 23. fokey14 smallint 2 2 24. fokey15 smallint 2 2 25. fokey16 smallint 2 2 26. refkey1 smallint 2 2 27. refkey2 smallint 2 2 28. refkey3 smallint 2 2 29. refkey4 smallint 2 2 30. refkey5 smallint 2 2 31. refkey6 smallint 2 2 32. refkey7 smallint 2 2 33. refkey8 smallint 2 2 34. refkey9 smallint 2 2 35. refkey10 smallint 2 2 36. refkey11 smallint 2 2 37. refkey12 smallint 2 2 38. refkey13 smallint 2 2 39. refkey14 smallint 2 2 40. refkey15 smallint 2 2 41. refkey16 smallint 2 2 42. frgndbname varchar 30 30 Yes 43. pmrydbname varchar 30 30 Yes Indexes for dbo.sysreferences: Name Attributes Segment Columns --------------------------------------------------- csysreferences (c) default tableid, frgndbname ncsysreferences default constrid, frgndbname nc2sysreferences default reftabid, indexid, pmrydbname Permissions on dbo.sysreferences: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 46. dbo.sysremotelogins # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ................................................................................. 1. remoteserverid smallint 2 2 2. remoteusername varchar 30 30 Yes 3. suid int 4 4 4. status smallint 2 2 Indexes for dbo.sysremotelogins: Name Attributes Segment Columns --------------------------------------------------- csysremotelogins (uc) default remoteserverid, remoteusername sp_primarykey defined for dbo.sysremotelogins: Column 1: remoteserverid Column 2: remoteusername Outgoing sp_commonkeys from dbo.sysremotelogins: 1. sp_commonkey references table master.dbo.sysusers Column suid to sysusers.suid sp_commonkeys coming into dbo.sysremotelogins from other tables: 1. sp_commonkey from table master.dbo.sysservers sysservers.srvid to column remoteserverid Permissions on dbo.sysremotelogins: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ................................................................................. 47. dbo.sysresourcelimits # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. name varchar 30 30 Yes 2. appname varchar 30 30 Yes 3. rangeid smallint 2 2 4. limitid smallint 2 2 5. enforced tinyint 1 1 6. action tinyint 1 1 7. limitvalue int 4 4 8. scope tinyint 1 1 9. spare tinyint 1 1 Indexes for dbo.sysresourcelimits: Name Attributes Segment Columns ----------------------------------------------------- csysresourcelimits (c) system name, appname Permissions on dbo.sysresourcelimits: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 48. dbo.sysroles # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ......................................................................... 1. id int 4 4 2. lrid int 4 4 3. type smallint 2 2 4. status int 4 4 Indexes for dbo.sysroles: Name Attributes Segment Columns -------------------------------------------- csysroles (uc) system lrid ......................................................................... 49. dbo.syssecmechs # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .................................................................................... 1. sec_mech_name varchar 30 30 2. available_service varchar 30 30 dbo.syssecmechs has no indexes. .................................................................................... 50. dbo.syssegments # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. segment smallint 2 2 2. name sysname 30 30 3. status smallint 2 2 Yes dbo.syssegments has no indexes. sp_commonkeys coming into dbo.syssegments from other tables: 1. sp_commonkey from table master.dbo.sysindexes sysindexes.segment to column segment Permissions on dbo.syssegments: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 51. dbo.sysservers # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. srvid smallint 2 2 2. srvstatus smallint 2 2 3. srvname varchar 30 30 4. srvnetname varchar 32 32 5. srvclass smallint 2 2 Yes 6. srvsecmech varchar 30 30 Yes 7. srvcost smallint 2 2 Yes Indexes for dbo.sysservers: Name Attributes Segment Columns ----------------------------------------------- csysservers (uc) default srvid ncsysservers (u) default srvname sp_primarykey defined for dbo.sysservers: Column 1: srvid Outgoing sp_commonkeys from dbo.sysservers: 1. sp_commonkey references table master.dbo.sysremotelogins Column srvid to sysremotelogins.remoteserverid Permissions on dbo.sysservers: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 52. dbo.syssessions # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ......................................................................... 1. sys_id smallint 2 2 2. ses_id int 4 4 3. state tinyint 1 1 4. spare tinyint 1 1 5. status smallint 2 2 6. dbid smallint 2 2 7. name varchar 30 30 Yes dbo.syssessions has no indexes. ......................................................................... 53. dbo.syssrvroles # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. srid int 4 4 2. name varchar 30 30 3. password varbinary 30 30 Yes 4. pwdate datetime 8 8 Yes 5. status smallint 2 2 Yes 6. logincount smallint 2 2 Yes Indexes for dbo.syssrvroles: Name Attributes Segment Columns ----------------------------------------------- csyssrvroles (uc) system srid .............................................................................. 54. dbo.sysstatistics # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. statid smallint 2 2 2. id int 4 4 3. sequence int 4 4 4. moddate datetime 8 8 5. formatid tinyint 1 1 6. usedcount tinyint 1 1 7. colidarray varbinary 100 100 Yes 8. c0 varbinary 255 255 Yes 9. c1 varbinary 255 255 Yes 10. c2 varbinary 255 255 Yes 11. c3 varbinary 255 255 Yes 12. c4 varbinary 255 255 Yes 13. c5 varbinary 255 255 Yes 14. c6 varbinary 255 255 Yes 15. c7 varbinary 255 255 Yes 16. c8 varbinary 255 255 Yes 17. c9 varbinary 255 255 Yes 18. c10 varbinary 255 255 Yes 19. c11 varbinary 255 255 Yes 20. c12 varbinary 255 255 Yes 21. c13 varbinary 255 255 Yes 22. c14 varbinary 255 255 Yes 23. c15 varbinary 255 255 Yes 24. c16 varbinary 255 255 Yes 25. c17 varbinary 255 255 Yes 26. c18 varbinary 255 255 Yes 27. c19 varbinary 255 255 Yes 28. c20 varbinary 255 255 Yes 29. c21 varbinary 255 255 Yes 30. c22 varbinary 255 255 Yes 31. c23 varbinary 255 255 Yes 32. c24 varbinary 255 255 Yes 33. c25 varbinary 255 255 Yes 34. c26 varbinary 255 255 Yes 35. c27 varbinary 255 255 Yes 36. c28 varbinary 255 255 Yes 37. c29 varbinary 255 255 Yes 38. c30 varbinary 255 255 Yes 39. c31 varbinary 255 255 Yes 40. c32 varbinary 255 255 Yes 41. c33 varbinary 255 255 Yes 42. c34 varbinary 255 255 Yes 43. c35 varbinary 255 255 Yes 44. c36 varbinary 255 255 Yes 45. c37 varbinary 255 255 Yes 46. c38 varbinary 255 255 Yes 47. c39 varbinary 255 255 Yes 48. c40 varbinary 255 255 Yes 49. c41 varbinary 255 255 Yes 50. c42 varbinary 255 255 Yes 51. c43 varbinary 255 255 Yes 52. c44 varbinary 255 255 Yes 53. c45 varbinary 255 255 Yes 54. c46 varbinary 255 255 Yes 55. c47 varbinary 255 255 Yes 56. c48 varbinary 255 255 Yes 57. c49 varbinary 255 255 Yes 58. c50 varbinary 255 255 Yes 59. c51 varbinary 255 255 Yes 60. c52 varbinary 255 255 Yes 61. c53 varbinary 255 255 Yes 62. c54 varbinary 255 255 Yes 63. c55 varbinary 255 255 Yes 64. c56 varbinary 255 255 Yes 65. c57 varbinary 255 255 Yes 66. c58 varbinary 255 255 Yes 67. c59 varbinary 255 255 Yes 68. c60 varbinary 255 255 Yes 69. c61 varbinary 255 255 Yes 70. c62 varbinary 255 255 Yes 71. c63 varbinary 255 255 Yes 72. c64 varbinary 255 255 Yes 73. c65 varbinary 255 255 Yes 74. c66 varbinary 255 255 Yes 75. c67 varbinary 255 255 Yes 76. c68 varbinary 255 255 Yes 77. c69 varbinary 255 255 Yes 78. c70 varbinary 255 255 Yes 79. c71 varbinary 255 255 Yes 80. c72 varbinary 255 255 Yes 81. c73 varbinary 255 255 Yes 82. c74 varbinary 255 255 Yes 83. c75 varbinary 255 255 Yes 84. c76 varbinary 255 255 Yes 85. c77 varbinary 255 255 Yes 86. c78 varbinary 255 255 Yes 87. c79 varbinary 255 255 Yes Indexes for dbo.sysstatistics: Name Attributes Segment Columns ------------------------------------------------- csysstatistics (u) system id, statid, colidarray, formatid, sequence .............................................................................. 55. dbo.systabstats # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................... 1. indid smallint 2 2 2. id int 4 4 3. activestatid smallint 2 2 4. indexheight smallint 2 2 5. leafcnt int 4 4 6. pagecnt int 4 4 7. rowcnt float 8 8 8. forwrowcnt float 8 8 9. delrowcnt float 8 8 10. dpagecrcnt float 8 8 11. ipagecrcnt float 8 8 12. drowcrcnt float 8 8 13. oamapgcnt int 4 4 14. extent0pgcnt int 4 4 15. datarowsize float 8 8 16. leafrowsize float 8 8 17. status int 4 4 18. spare1 int 4 4 19. spare2 float 8 8 20. rslastoam int 4 4 21. rslastpage int 4 4 22. frlastoam int 4 4 23. frlastpage int 4 4 24. conopt_thld smallint 2 2 25. spare3 smallint 2 2 26. emptypgcnt int 4 4 27. spare4 float 8 8 Indexes for dbo.systabstats: Name Attributes Segment Columns ----------------------------------------------- csystabstats (u) system id, indid Permissions on dbo.systabstats: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................... 56. dbo.systestlog # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. iterations int 4 4 2. kpid int 4 4 3. iterdate datetime 8 8 dbo.systestlog has no indexes. ............................................................................. 57. dbo.systhresholds # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. segment smallint 2 2 2. free_space int 4 4 3. status smallint 2 2 4. proc_name varchar 255 255 5. suid int 4 4 Yes 6. currauth varbinary 255 255 Yes Indexes for dbo.systhresholds: Name Attributes Segment Columns ------------------------------------------------- csysthresholds (c) system segment, free_space .............................................................................. 58. dbo.systimeranges # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................ 1. name varchar 30 30 2. id smallint 2 2 3. startday tinyint 1 1 4. endday tinyint 1 1 5. starttime varchar 10 10 6. endtime varchar 10 10 Indexes for dbo.systimeranges: Name Attributes Segment Columns ------------------------------------------------- csystimeranges (c) system id Permissions on dbo.systimeranges: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................ 59. dbo.systransactions # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. xactkey binary 14 14 2. starttime datetime 8 8 3. failover int 4 4 4. type int 4 4 5. coordinator int 4 4 6. state int 4 4 7. connection int 4 4 8. status int 4 4 9. status2 int 4 4 10. spid smallint 2 2 11. masterdbid smallint 2 2 12. loid int 4 4 13. namelen smallint 2 2 14. xactname varchar 255 255 Yes 15. srvname varchar 30 30 Yes dbo.systransactions has no indexes. Permissions on dbo.systransactions: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 60. dbo.systypes # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ............................................................................. 1. uid int 4 4 2. usertype smallint 2 2 3. variable bit 1 1 4. allownulls bit 1 1 5. type tinyint 1 1 6. length int 4 4 7. tdefault int 4 4 8. domain int 4 4 9. name sysname 30 30 10. printfmt varchar 255 255 Yes 11. prec tinyint 1 1 Yes 12. scale tinyint 1 1 Yes 13. ident tinyint 1 1 Yes 14. hierarchy tinyint 1 1 Yes 15. xtypeid int 4 4 Yes 16. xdbid int 4 4 Yes 17. accessrule int 4 4 Yes Indexes for dbo.systypes: Name Attributes Segment Columns --------------------------------------------- systypes (uc) system name ncsystypes (u) system usertype sp_primarykey defined for dbo.systypes: Column 1: name Outgoing sp_commonkeys from dbo.systypes: 1. sp_commonkey references table master.dbo.sysusers Column uid to sysusers.uid sp_commonkeys coming into dbo.systypes from other tables: 1. sp_commonkey from table master.dbo.syscolumns syscolumns.type to column type 2. sp_commonkey from table master.dbo.syscolumns syscolumns.usertype to column usertype 3. sp_commonkey from table master.dbo.syscolumns syscolumns.domain to column domain 4. sp_commonkey from table master.dbo.syscolumns syscolumns.cdefault to column tdefault Permissions on dbo.systypes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 61. dbo.sysusages # Column Datatype Len--Avg Prec Scale Null Def Rule Comments ................................................................................ 1. dbid smallint 2 2 2. segmap int 4 4 3. lstart int 4 4 4. size int 4 4 5. vstart int 4 4 6. pad smallint 2 2 Yes 7. unreservedpgs int 4 4 Yes 8. crdate datetime 8 8 Yes Indexes for dbo.sysusages: Name Attributes Segment Columns ---------------------------------------------- sysusages (uc) system dbid, lstart ncsysusages (u) system vstart sp_primarykey defined for dbo.sysusages: Column 1: dbid Column 2: lstart sp_commonkeys coming into dbo.sysusages from other tables: 1. sp_commonkey from table master.dbo.sysdatabases sysdatabases.dbid to column dbid Permissions on dbo.sysusages: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ................................................................................ 62. dbo.sysusermessages # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .............................................................................. 1. error int 4 4 2. uid int 4 4 3. description varchar 1024 1024 4. langid smallint 2 2 Yes 5. dlevel smallint 2 2 Yes Indexes for dbo.sysusermessages: Name Attributes Segment Columns ---------------------------------------------------- csysusermessages (c) default error ncsysusermessages (u) default error, langid Permissions on dbo.sysusermessages: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 63. dbo.sysusers # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .......................................................................... 1. suid int 4 4 2. uid int 4 4 3. gid int 4 4 4. name sysname 30 30 5. environ varchar 255 255 Yes Indexes for dbo.sysusers: Name Attributes Segment Columns ---------------------------------------------- sysusers (c) system suid ncsysusers1 (u) system name ncsysusers2 system uid sp_primarykey defined for dbo.sysusers: Column 1: suid sp_foreignkeys coming into dbo.sysusers from other tables: 1. sp_foreignkey from table master.dbo.sysalternates sysalternates.suid to column suid sp_commonkeys coming into dbo.sysusers from other tables: 1. sp_commonkey from table master.dbo.sysobjects sysobjects.uid to column uid 2. sp_commonkey from table master.dbo.systypes systypes.uid to column uid 3. sp_commonkey from table master.dbo.sysprotects sysprotects.uid to column uid 4. sp_commonkey from table master.dbo.sysremotelogins sysremotelogins.suid to column suid Permissions on dbo.sysusers: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 64. dbo.sysxtypes # Column Datatype Len--Avg Prec Scale Null Def Rule Comments .................................................................................. 1. xtutid smallint 2 2 2. xtid int 4 4 3. xtmetatype int 4 4 4. xtstatus int 4 4 5. xtcontainer int 4 4 6. xtname varchar 255 255 Yes 7. xtsource text 16 16 Yes 8. xtbinaryinrow varbinary 255 255 Yes 9. xtbinaryoffrow image 16 16 Yes Indexes for dbo.sysxtypes: Name Attributes Segment Columns ---------------------------------------------- csysxtypes (u) system xtid ncsysxtypes (u) system xtname Permissions on dbo.sysxtypes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .................................................................................. ------------------------------------------------------------------------------ Image/Text Chains --------------------------------------------------------------------------------- # Table Owner Image Image-Segment Image-Cache Columns 1. spt_jtext dbo tspt_jtext default (value) 2. sysattributes dbo tsysattributes system (text_value, image_value) 3. syscharsets dbo tsyscharsets default (definition) 4. sysjars dbo tsysjars system (jbinary) 5. sysxtypes dbo tsysxtypes system (xtsource, xtbinaryoffrow) --------------------------------------------------------------------------------- Approximate Row Counts ----------------------------------------------------------------------------------------------------- # Table Owner Segment Rows MinLen MaxLen Out-RI In-RI Triggers 1. ijdbc_function_escapes dbo default 88 2 88 0 0 2. jdbc_function_escapes dbo default 88 2 88 0 0 3. spt_ijdbc_conversion dbo default 20 26 26 0 0 4. spt_ijdbc_mda dbo default 175 13 1165 0 0 5. spt_ijdbc_table_types dbo default 3 17 17 0 0 6. spt_jdbc_conversion dbo default 20 26 26 0 0 7. spt_jdbc_table_types dbo default 3 17 17 0 0 8. spt_jtext dbo default 1 2 54 0 0 9. spt_limit_types dbo default 4 99 99 0 0 10. spt_mda dbo default 183 13 305 0 0 11. spt_monitor dbo system 1 50 50 0 0 12. spt_values dbo system 1658 8 58 0 0 13. syblicenseslog dbo default 17 16 16 0 0 14. sysalternates dbo system 0 12 12 0 0 15. sysattributes dbo system 505 8 616 0 0 16. syscertificates dbo system 0 50 84 0 0 17. syscharsets dbo default 8 8 348 0 0 18. syscolumns dbo system 78 32 389 0 0 19. syscomments dbo default 250 16 540 0 0 20. sysconfigures dbo default 227 12 624 0 0 21. sysconstraints dbo system 0 24 24 0 0 22. syscurconfigs dbo system 235 12 854 0 0 23. sysdatabases dbo system 6 38 366 0 0 24. sysdepends dbo system 30 22 22 0 0 25. sysdevices dbo system 6 14 306 0 0 26. sysengines dbo system 1 76 76 0 0 27. sysindexes dbo system 17 58 892 0 0 28. sysjars dbo system 0 12 64 0 0 29. syskeys dbo system 48 10 77 0 0 30. syslanguages dbo default 4 12 669 0 0 31. syslisteners dbo system 1 289 289 0 0 32. syslocks dbo system 0 16 64 0 0 33. sysloginroles dbo system 4 12 12 0 0 34. syslogins dbo system 3 36 248 0 0 35. syslogs dbo logsegment 598 12 273 0 0 36. syslogshold dbo system 0 104 113 0 0 37. sysmessages dbo system 26303 10 1052 0 0 38. sysmonitors dbo system 0 112 373 0 0 39. sysobjects dbo system 26 66 150 0 0 40. syspartitions dbo system 0 52 52 0 0 41. sysprocedures dbo system 3378 16 282 0 0 42. sysprocesses dbo system 8 118 425 0 0 43. sysprotects dbo system 58 14 157 0 0 44. sysqueryplans dbo system 0 26 291 0 0 45. sysreferences dbo default 0 92 158 0 0 46. sysremotelogins dbo default 0 10 45 0 0 47. sysresourcelimits dbo system 0 14 80 0 0 48. sysroles dbo system 6 16 16 0 0 49. syssecmechs dbo system 0 2 68 0 0 50. syssegments dbo system 3 4 42 0 0 51. sysservers dbo default 4 6 111 0 0 52. syssessions dbo system 0 18 52 0 0 53. syssrvroles dbo system 8 8 89 0 0 54. sysstatistics dbo system 0 26 8108 0 0 55. systabstats dbo system 16 144 144 0 0 56. systestlog dbo system 0 20 20 0 0 57. systhresholds dbo system 1 10 533 0 0 58. systimeranges dbo system 1 6 63 0 0 59. systransactions dbo default 0 62 354 0 0 60. systypes dbo system 31 22 337 0 0 61. sysusages dbo system 8 20 41 0 0 62. sysusermessages dbo default 0 10 1049 0 0 63. sysusers dbo system 10 16 308 0 0 64. sysxtypes dbo system 0 24 576 0 0 -----------------------------------------------------------------------------------------------------