List of Sybase Tables ------------------------------------------------------------------------------ SQL Server: secondsun Version: Adaptive Server Enterprise/12.5.2/EBF 11942 ESD#1/P/Sun_svr4/OS 5.8/ase1252/1838/64-bit/FBO/Sat May 29 11:32:09 2004 Database: model Sybase User: sa UNIX User: ceccareb Owner Pattern: Table Pattern: Order: Alphabetical Time: Sun Dec 26 14:58:21 2004 ......................................................... 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.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 model.dbo.sysusers Column suid to sysusers.suid Permissions on dbo.sysalternates: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 2. 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 ............................................................................... 3. 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 model.dbo.syscomments Column id to syscomments.id 2. sp_commonkey references table model.dbo.syskeys Column id to syskeys.key1 3. sp_commonkey references table model.dbo.syskeys Column id to syskeys.depkey1 4. sp_commonkey references table model.dbo.sysobjects Column id to sysobjects.id 5. sp_commonkey references table model.dbo.systypes Column type to systypes.type 6. sp_commonkey references table model.dbo.systypes Column usertype to systypes.usertype 7. sp_commonkey references table model.dbo.systypes Column domain to systypes.domain 8. sp_commonkey references table model.dbo.systypes Column cdefault to systypes.tdefault Permissions on dbo.syscolumns: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 4. 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 model.dbo.sysobjects Column id to sysobjects.id sp_commonkeys coming into dbo.syscomments from other tables: 1. sp_commonkey from table model.dbo.syscolumns syscolumns.id to column id Permissions on dbo.syscomments: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ........................................................................... 5. 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 ........................................................................... 6. 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 model.dbo.sysobjects Column id to sysobjects.id Permissions on dbo.sysdepends: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................ 7. 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 model.dbo.sysobjects Column id to sysobjects.id 2. sp_commonkey references table model.dbo.syssegments Column segment to syssegments.segment Permissions on dbo.sysindexes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .................................................................................. 8. 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 .......................................................................... 9. 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 model.dbo.sysobjects Column id to sysobjects.id Outgoing sp_commonkeys from dbo.syskeys: 1. sp_commonkey references table model.dbo.sysobjects Column depid to sysobjects.id sp_commonkeys coming into dbo.syskeys from other tables: 1. sp_commonkey from table model.dbo.syscolumns syscolumns.id to column key1 2. sp_commonkey from table model.dbo.syscolumns syscolumns.id to column depkey1 Permissions on dbo.syskeys: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 10. 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 ......................................................................... 11. 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 model.dbo.syskeys syskeys.id to column id Outgoing sp_commonkeys from dbo.sysobjects: 1. sp_commonkey references table model.dbo.sysprocedures Column id to sysprocedures.id 2. sp_commonkey references table model.dbo.sysprotects Column id to sysprotects.id 3. sp_commonkey references table model.dbo.sysusers Column uid to sysusers.uid sp_commonkeys coming into dbo.sysobjects from other tables: 1. sp_commonkey from table model.dbo.sysindexes sysindexes.id to column id 2. sp_commonkey from table model.dbo.syscolumns syscolumns.id to column id 3. sp_commonkey from table model.dbo.syscomments syscomments.id to column id 4. sp_commonkey from table model.dbo.sysdepends sysdepends.id to column id 5. sp_commonkey from table model.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 ............................................................................ 12. 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 Permissions on dbo.syspartitions: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 13. 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 model.dbo.sysobjects sysobjects.id to column id Permissions on dbo.sysprocedures: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ........................................................................... 14. 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 model.dbo.sysusers Column uid to sysusers.uid sp_commonkeys coming into dbo.sysprotects from other tables: 1. sp_commonkey from table model.dbo.sysobjects sysobjects.id to column id Permissions on dbo.sysprotects: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................... 15. 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 Permissions on dbo.sysqueryplans: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ........................................................................... 16. 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 ............................................................................. 17. 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 Permissions on dbo.sysroles: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ......................................................................... 18. 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_primarykey defined for dbo.syssegments: Column 1: segment sp_commonkeys coming into dbo.syssegments from other tables: 1. sp_commonkey from table model.dbo.sysindexes sysindexes.segment to column segment Permissions on dbo.syssegments: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 19. 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 Permissions on dbo.sysstatistics: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 20. 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 ............................................................................... 21. 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 Permissions on dbo.systhresholds: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .............................................................................. 22. 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 model.dbo.sysusers Column uid to sysusers.uid sp_commonkeys coming into dbo.systypes from other tables: 1. sp_commonkey from table model.dbo.syscolumns syscolumns.type to column type 2. sp_commonkey from table model.dbo.syscolumns syscolumns.usertype to column usertype 3. sp_commonkey from table model.dbo.syscolumns syscolumns.domain to column domain 4. sp_commonkey from table model.dbo.syscolumns syscolumns.cdefault to column tdefault Permissions on dbo.systypes: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo ............................................................................. 23. 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 .............................................................................. 24. 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 (u) 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 model.dbo.sysalternates sysalternates.suid to column suid sp_commonkeys coming into dbo.sysusers from other tables: 1. sp_commonkey from table model.dbo.sysobjects sysobjects.uid to column uid 2. sp_commonkey from table model.dbo.systypes systypes.uid to column uid 3. sp_commonkey from table model.dbo.sysprotects sysprotects.uid to column uid Permissions on dbo.sysusers: # User/Group Protect-Type Action Columns Grantor ------------------------------------------------------------------------------------------------------- 1. public grant select 0x01 dbo .......................................................................... 25. 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. sysattributes dbo tsysattributes system (text_value, image_value) 2. sysjars dbo tsysjars system (jbinary) 3. sysxtypes dbo tsysxtypes system (xtsource, xtbinaryoffrow) --------------------------------------------------------------------------------- Approximate Row Counts ---------------------------------------------------------------------------------------------- # Table Owner Segment Rows MinLen MaxLen Out-RI In-RI Triggers 1. sysalternates dbo system 0 12 12 0 0 2. sysattributes dbo system 33 8 616 0 0 3. syscolumns dbo system 369 32 389 0 0 4. syscomments dbo default 0 16 540 0 0 5. sysconstraints dbo system 0 24 24 0 0 6. sysdepends dbo system 0 22 22 0 0 7. sysindexes dbo system 46 58 892 0 0 8. sysjars dbo system 0 12 64 0 0 9. syskeys dbo system 32 10 77 0 0 10. syslogs dbo logsegment 164 12 273 0 0 11. sysobjects dbo system 26 66 150 0 0 12. syspartitions dbo system 0 52 52 0 0 13. sysprocedures dbo system 0 16 282 0 0 14. sysprotects dbo system 26 14 157 0 0 15. sysqueryplans dbo system 0 26 291 0 0 16. sysreferences dbo default 0 92 158 0 0 17. sysroles dbo system 10 16 16 0 0 18. syssegments dbo system 3 4 42 0 0 19. sysstatistics dbo system 0 26 16300 0 0 20. systabstats dbo system 43 144 144 0 0 21. systhresholds dbo system 1 10 533 0 0 22. systypes dbo system 35 22 337 0 0 23. sysusermessages dbo default 0 10 1049 0 0 24. sysusers dbo system 12 16 308 0 0 25. sysxtypes dbo system 0 24 576 0 0 ----------------------------------------------------------------------------------------------