dbschemasall.asp

adSchemaAsserts
is not supported

adSchemaCharacterSets
is not supported

adSchemaCollations
is not supported

adSchemaColumns
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_GUID COLUMN_PROPID ORDINAL_POSITION COLUMN_HASDEFAULT COLUMN_DEFAULT COLUMN_FLAGS IS_NULLABLE DATA_TYPE TYPE_GUID CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME DESCRIPTION SS_DATA_TYPE
Learnasp dbo Authors Au_ID 1 False 24 False 3 10 56
Learnasp dbo Authors Author 2 False 104 True 130 50 100 39
Learnasp dbo Authors Year_ Born 3 False 120 True 2 5 38
Learnasp dbo dtproperties id 1 False 24 False 3 10 56
Learnasp dbo dtproperties objectid 2 False 120 True 3 10 38
Learnasp dbo dtproperties property 3 False 8 False 129 64 64 39
Learnasp dbo dtproperties value 4 False 104 True 129 255 255 39
Learnasp dbo dtproperties uvalue 5 False 104 True 130 255 510 39
Learnasp dbo dtproperties lvalue 6 False 232 True 128 2147483647 2147483647 34
Learnasp dbo dtproperties version 7 True (0) 24 False 3 10 56
Learnasp dbo junk_NotFound keyNotFound 1 False 24 False 3 10 56
Learnasp dbo junk_NotFound RequestUriStem 2 False 8 False 129 200 200 39
Learnasp dbo junk_NotFound NumRequests 3 True (1) 24 False 3 10 56
Learnasp dbo junk_NotFound LastRequestDate 4 True (getdate()) 120 True 135 9 111
Learnasp dbo junk_NotFound RedirectUriStem 5 False 104 True 129 200 200 39
Learnasp dbo NFlog NFLogKey 1 False 24 False 3 10 56
Learnasp dbo NFlog URL 2 False 8 False 129 200 200 39
Learnasp dbo NFlog NumRequests 3 False 120 True 3 10 38
Learnasp dbo NFlog NumRequestsCorrected 4 True (0) 120 True 3 10 38
Learnasp dbo NFlog LastRequest 5 True (getdate()) 120 True 135 9 111
Learnasp dbo NFlog LogDetails 6 True (1) 120 True 11 50
Learnasp dbo NFlog Ignore 7 True (0) 120 True 11 50
Learnasp dbo NFLogDetails NFLogDetails 1 False 24 False 3 10 56
Learnasp dbo NFLogDetails NFLogKey 2 False 120 True 3 10 38
Learnasp dbo NFLogDetails Key_NFLogQueryDetails 3 False 120 True 3 10 38
Learnasp dbo NFLogDetails When 4 True (getdate()) 120 True 135 9 111
Learnasp dbo NFLogDetails URL 5 False 104 True 129 200 200 39
Learnasp dbo NFLogDetails QueryString 6 False 104 True 129 200 200 39
Learnasp dbo NFLogDetails Referrer 7 False 104 True 129 300 300 39
Learnasp dbo NFLogDetails UserAgent 8 False 104 True 129 300 300 39
Learnasp dbo NFLogDetails UserHostAddress 9 False 104 True 129 50 50 39
Learnasp dbo NFLogDetails UserHostName 10 False 104 True 129 100 100 39
Learnasp dbo NFLogQueryDetails NFLogQueryDetails 1 False 24 False 3 10 56
Learnasp dbo NFLogQueryDetails URL 2 False 104 True 129 200 200 39
Learnasp dbo NFLogQueryDetails QueryString 3 False 104 True 129 200 200 39
Learnasp dbo NFLogQueryDetails Referrer 4 False 104 True 129 300 300 39
Learnasp dbo NFLogQueryDetails UserAgent 5 False 104 True 129 300 300 39
Learnasp dbo NFLogQueryDetails UserHostAddress 6 False 104 True 129 50 50 39
Learnasp dbo NFLogQueryDetails UserHostName 7 False 104 True 129 100 100 39
Learnasp dbo NFLogQueryDetails Checksum 8 False 8 False 129 64 64 39
Learnasp dbo NFredirects NFredirectskey 1 False 24 False 3 10 56
Learnasp dbo NFredirects URL 2 False 104 True 129 100 100 39
Learnasp dbo NFredirects URLNew 3 False 104 True 129 200 200 39
Learnasp dbo publishers PubID 1 False 24 False 3 10 56
Learnasp dbo publishers Name 2 False 104 True 130 50 100 39
Learnasp dbo publishers Company Name 3 False 104 True 130 255 510 39
Learnasp dbo publishers Address 4 False 104 True 130 50 100 39
Learnasp dbo publishers City 5 False 104 True 130 20 40 39
Learnasp dbo publishers State 6 False 104 True 130 10 20 39
Learnasp dbo publishers Zip 7 False 104 True 130 15 30 39
Learnasp dbo publishers Telephone 8 False 104 True 130 15 30 39
Learnasp dbo publishers Fax 9 False 104 True 130 15 30 39
Learnasp dbo publishers Comments 10 False 232 True 130 1073741823 2147483646 35
Learnasp dbo PublishersNew PubID 1 False 24 False 3 10 56
Learnasp dbo PublishersNew Name 2 False 104 True 130 50 100 39
Learnasp dbo PublishersNew Company Name 3 False 104 True 130 255 510 39
Learnasp dbo PublishersNew Address 4 False 104 True 130 50 100 39
Learnasp dbo PublishersNew City 5 False 104 True 130 20 40 39
Learnasp dbo PublishersNew State 6 False 104 True 130 10 20 39
Learnasp dbo PublishersNew Zip 7 False 104 True 130 15 30 39
Learnasp dbo PublishersNew Telephone 8 False 104 True 130 15 30 39
Learnasp dbo PublishersNew Fax 9 False 104 True 130 15 30 39
Learnasp dbo PublishersNew Comments 10 False 232 True 130 1073741823 2147483646 35
Learnasp dbo syscolumns name 1 False 8 False 130 128 256 39
Learnasp dbo syscolumns id 2 False 24 False 3 10 56
Learnasp dbo syscolumns xtype 3 False 24 False 17 3 48
Learnasp dbo syscolumns typestat 4 False 24 False 17 3 48
Learnasp dbo syscolumns xusertype 5 False 24 False 2 5 52
Learnasp dbo syscolumns length 6 False 24 False 2 5 52
Learnasp dbo syscolumns xprec 7 False 24 False 17 3 48
Learnasp dbo syscolumns xscale 8 False 24 False 17 3 48
Learnasp dbo syscolumns colid 9 False 24 False 2 5 52
Learnasp dbo syscolumns xoffset 10 False 24 False 2 5 52
Learnasp dbo syscolumns bitpos 11 False 24 False 17 3 48
Learnasp dbo syscolumns reserved 12 False 24 False 17 3 48
Learnasp dbo syscolumns colstat 13 False 24 False 2 5 52
Learnasp dbo syscolumns cdefault 14 False 24 False 3 10 56
Learnasp dbo syscolumns domain 15 False 24 False 3 10 56
Learnasp dbo syscolumns number 16 False 24 False 2 5 52
Learnasp dbo syscolumns colorder 17 False 24 False 2 5 52
Learnasp dbo syscolumns autoval 18 False 104 True 128 8000 8000 37
Learnasp dbo syscolumns offset 19 False 24 False 2 5 52
Learnasp dbo syscolumns collationid 20 False 120 True 3 10 38
Learnasp dbo syscolumns language 21 False 24 False 3 10 56
Learnasp dbo syscolumns status 22 False 120 True 17 3 38
Learnasp dbo syscolumns type 23 False 120 True 17 3 38
Learnasp dbo syscolumns usertype 24 False 120 True 2 5 38
Learnasp dbo syscolumns printfmt 25 False 104 True 129 255 255 39
Learnasp dbo syscolumns prec 26 False 120 True 2 5 38
Learnasp dbo syscolumns scale 27 False 120 True 3 10 38
Learnasp dbo syscolumns iscomputed 28 False 120 True 3 10 38
Learnasp dbo syscolumns isoutparam 29 False 120 True 3 10 38
Learnasp dbo syscolumns isnullable 30 False 120 True 3 10 38
Learnasp dbo syscolumns collation 31 False 104 True 130 128 256 39
Learnasp dbo syscolumns tdscollation 32 False 120 True 128 5 5 37
Learnasp dbo syscomments id 1 False 24 False 3 10 56
Learnasp dbo syscomments number 2 False 24 False 2 5 52
Learnasp dbo syscomments colid 3 False 24 False 2 5 52
Learnasp dbo syscomments status 4 False 24 False 2 5 52
Learnasp dbo syscomments ctext 5 False 8 False 128 8000 8000 37
Learnasp dbo syscomments texttype 6 False 120 True 2 5 38
Learnasp dbo syscomments language 7 False 120 True 2 5 38
Learnasp dbo syscomments encrypted 8 False 120 True 11 50
Learnasp dbo syscomments compressed 9 False 120 True 11 50
Learnasp dbo syscomments text 10 False 104 True 130 4000 8000 39
Learnasp dbo sysconstraints constid 1 False 120 True 3 10 38
Learnasp dbo sysconstraints id 2 False 120 True 3 10 38
Learnasp dbo sysconstraints colid 3 False 120 True 2 5 38
Learnasp dbo sysconstraints spare1 4 False 120 True 17 3 38
Learnasp dbo sysconstraints status 5 False 120 True 3 10 38
Learnasp dbo sysconstraints actions 6 False 120 True 3 10 38
Learnasp dbo sysconstraints error 7 False 120 True 3 10 38
Learnasp dbo sysdepends id 1 False 24 False 3 10 56
Learnasp dbo sysdepends depid 2 False 24 False 3 10 56
Learnasp dbo sysdepends number 3 False 24 False 2 5 52
Learnasp dbo sysdepends depnumber 4 False 24 False 2 5 52
Learnasp dbo sysdepends status 5 False 24 False 2 5 52
Learnasp dbo sysdepends deptype 6 False 24 False 17 3 48
Learnasp dbo sysdepends depdbid 7 False 120 True 2 5 38
Learnasp dbo sysdepends depsiteid 8 False 120 True 2 5 38
Learnasp dbo sysdepends selall 9 False 120 True 11 50
Learnasp dbo sysdepends resultobj 10 False 120 True 11 50
Learnasp dbo sysdepends readobj 11 False 120 True 11 50
Learnasp dbo sysfilegroups groupid 1 False 24 False 2 5 52
Learnasp dbo sysfilegroups allocpolicy 2 False 24 False 2 5 52
Learnasp dbo sysfilegroups status 3 False 24 False 3 10 56
Learnasp dbo sysfilegroups groupname 4 False 8 False 130 128 256 39
Learnasp dbo sysfiles fileid 1 False 24 False 2 5 52
Learnasp dbo sysfiles groupid 2 False 24 False 2 5 52
Learnasp dbo sysfiles size 3 False 24 False 3 10 56
Learnasp dbo sysfiles maxsize 4 False 24 False 3 10 56
Learnasp dbo sysfiles growth 5 False 24 False 3 10 56
Learnasp dbo sysfiles status 6 False 24 False 3 10 56
Learnasp dbo sysfiles perf 7 False 24 False 3 10 56
Learnasp dbo sysfiles name 8 False 24 False 130 128 256 47
Learnasp dbo sysfiles filename 9 False 24 False 130 260 520 47
Learnasp dbo sysfiles1 status 1 False 24 False 3 10 56
Learnasp dbo sysfiles1 fileid 2 False 24 False 2 5 52
Learnasp dbo sysfiles1 name 3 False 24 False 130 128 256 47
Learnasp dbo sysfiles1 filename 4 False 24 False 130 260 520 47
Learnasp dbo sysforeignkeys constid 1 False 24 False 3 10 56
Learnasp dbo sysforeignkeys fkeyid 2 False 24 False 3 10 56
Learnasp dbo sysforeignkeys rkeyid 3 False 24 False 3 10 56
Learnasp dbo sysforeignkeys fkey 4 False 24 False 2 5 52
Learnasp dbo sysforeignkeys rkey 5 False 24 False 2 5 52
Learnasp dbo sysforeignkeys keyno 6 False 24 False 2 5 52
Learnasp dbo sysfulltextcatalogs ftcatid 1 False 24 False 2 5 52
Learnasp dbo sysfulltextcatalogs name 2 False 8 False 130 128 256 39
Learnasp dbo sysfulltextcatalogs status 3 False 24 False 2 5 52
Learnasp dbo sysfulltextcatalogs path 4 False 104 True 130 260 520 39
Learnasp dbo sysfulltextnotify tableid 1 False 24 False 3 10 56
Learnasp dbo sysfulltextnotify rowinfo 2 False 24 False 2 5 52
Learnasp dbo sysfulltextnotify ftkey 3 False 8 False 128 896 896 37
Learnasp dbo sysindexes id 1 False 24 False 3 10 56
Learnasp dbo sysindexes status 2 False 24 False 3 10 56
Learnasp dbo sysindexes first 3 False 24 False 128 6 6 45
Learnasp dbo sysindexes indid 4 False 24 False 2 5 52
Learnasp dbo sysindexes root 5 False 24 False 128 6 6 45
Learnasp dbo sysindexes minlen 6 False 24 False 2 5 52
Learnasp dbo sysindexes keycnt 7 False 24 False 2 5 52
Learnasp dbo sysindexes groupid 8 False 24 False 2 5 52
Learnasp dbo sysindexes dpages 9 False 24 False 3 10 56
Learnasp dbo sysindexes reserved 10 False 24 False 3 10 56
Learnasp dbo sysindexes used 11 False 24 False 3 10 56
Learnasp dbo sysindexes rowcnt 12 False 24 False 20 19 63
Learnasp dbo sysindexes rowmodctr 13 False 24 False 3 10 56
Learnasp dbo sysindexes reserved3 14 False 24 False 17 3 48
Learnasp dbo sysindexes reserved4 15 False 24 False 17 3 48
Learnasp dbo sysindexes xmaxlen 16 False 24 False 2 5 52
Learnasp dbo sysindexes maxirow 17 False 24 False 2 5 52
Learnasp dbo sysindexes OrigFillFactor 18 False 24 False 17 3 48
Learnasp dbo sysindexes StatVersion 19 False 24 False 17 3 48
Learnasp dbo sysindexes reserved2 20 False 24 False 3 10 56
Learnasp dbo sysindexes FirstIAM 21 False 24 False 128 6 6 45
Learnasp dbo sysindexes impid 22 False 24 False 2 5 52
Learnasp dbo sysindexes lockflags 23 False 24 False 2 5 52
Learnasp dbo sysindexes pgmodctr 24 False 24 False 3 10 56
Learnasp dbo sysindexes keys 25 False 104 True 128 1088 1088 37
Learnasp dbo sysindexes name 26 False 8 False 130 128 256 39
Learnasp dbo sysindexes statblob 27 False 232 True 128 2147483647 2147483647 34
Learnasp dbo sysindexes maxlen 28 False 24 False 3 10 56
Learnasp dbo sysindexes rows 29 False 120 True 3 10 38
Learnasp dbo sysindexkeys id 1 False 24 False 3 10 56
Learnasp dbo sysindexkeys indid 2 False 24 False 2 5 52
Learnasp dbo sysindexkeys colid 3 False 24 False 2 5 52
Learnasp dbo sysindexkeys keyno 4 False 24 False 2 5 52
Learnasp dbo sysmembers memberuid 1 False 24 False 2 5 52
Learnasp dbo sysmembers groupuid 2 False 24 False 2 5 52
Learnasp dbo sysobjects name 1 False 8 False 130 128 256 39
Learnasp dbo sysobjects id 2 False 24 False 3 10 56
Learnasp dbo sysobjects xtype 3 False 24 False 129 2 2 47
Learnasp dbo sysobjects uid 4 False 24 False 2 5 52
Learnasp dbo sysobjects info 5 False 24 False 2 5 52
Learnasp dbo sysobjects status 6 False 24 False 3 10 56
Learnasp dbo sysobjects base_schema_ver 7 False 24 False 3 10 56
Learnasp dbo sysobjects replinfo 8 False 24 False 3 10 56
Learnasp dbo sysobjects parent_obj 9 False 24 False 3 10 56
Learnasp dbo sysobjects crdate 10 False 24 False 135 9 61
Learnasp dbo sysobjects ftcatid 11 False 24 False 2 5 52
Learnasp dbo sysobjects schema_ver 12 False 24 False 3 10 56
Learnasp dbo sysobjects stats_schema_ver 13 False 24 False 3 10 56
Learnasp dbo sysobjects type 14 False 120 True 129 2 2 39
Learnasp dbo sysobjects userstat 15 False 120 True 2 5 38
Learnasp dbo sysobjects sysstat 16 False 120 True 2 5 38
Learnasp dbo sysobjects indexdel 17 False 120 True 2 5 38
Learnasp dbo sysobjects refdate 18 False 120 True 135 9 111
Learnasp dbo sysobjects version 19 False 120 True 3 10 38
Learnasp dbo sysobjects deltrig 20 False 120 True 3 10 38
Learnasp dbo sysobjects instrig 21 False 120 True 3 10 38
Learnasp dbo sysobjects updtrig 22 False 120 True 3 10 38
Learnasp dbo sysobjects seltrig 23 False 120 True 3 10 38
Learnasp dbo sysobjects category 24 False 120 True 3 10 38
Learnasp dbo sysobjects cache 25 False 120 True 2 5 38
Learnasp dbo syspermissions id 1 False 24 False 3 10 56
Learnasp dbo syspermissions grantee 2 False 24 False 2 5 52
Learnasp dbo syspermissions grantor 3 False 24 False 2 5 52
Learnasp dbo syspermissions actadd 4 False 24 False 2 5 52
Learnasp dbo syspermissions actmod 5 False 24 False 2 5 52
Learnasp dbo syspermissions seladd 6 False 104 True 128 4000 4000 37
Learnasp dbo syspermissions selmod 7 False 104 True 128 4000 4000 37
Learnasp dbo syspermissions updadd 8 False 104 True 128 4000 4000 37
Learnasp dbo syspermissions updmod 9 False 104 True 128 4000 4000 37
Learnasp dbo syspermissions refadd 10 False 104 True 128 4000 4000 37
Learnasp dbo syspermissions refmod 11 False 104 True 128 4000 4000 37
Learnasp dbo sysproperties id 1 False 24 False 3 10 56
Learnasp dbo sysproperties smallid 2 False 24 False 2 5 52
Learnasp dbo sysproperties type 3 False 24 False 17 3 48
Learnasp dbo sysproperties name 4 False 8 False 130 128 256 39
Learnasp dbo sysproperties value 5 False 120 True 128 0 8000 39
Learnasp dbo sysprotects id 1 False 24 False 3 10 56
Learnasp dbo sysprotects uid 2 False 24 False 2 5 52
Learnasp dbo sysprotects action 3 False 24 False 17 3 48
Learnasp dbo sysprotects protecttype 4 False 24 False 17 3 48
Learnasp dbo sysprotects columns 5 False 104 True 128 4000 4000 37
Learnasp dbo sysprotects grantor 6 False 24 False 2 5 52
Learnasp dbo sysreferences constid 1 False 24 False 3 10 56
Learnasp dbo sysreferences fkeyid 2 False 24 False 3 10 56
Learnasp dbo sysreferences rkeyid 3 False 24 False 3 10 56
Learnasp dbo sysreferences rkeyindid 4 False 24 False 2 5 52
Learnasp dbo sysreferences keycnt 5 False 24 False 2 5 52
Learnasp dbo sysreferences forkeys 6 False 8 False 128 32 32 37
Learnasp dbo sysreferences refkeys 7 False 8 False 128 32 32 37
Learnasp dbo sysreferences fkeydbid 8 False 120 True 2 5 38
Learnasp dbo sysreferences rkeydbid 9 False 120 True 2 5 38
Learnasp dbo sysreferences fkey1 10 False 120 True 2 5 38
Learnasp dbo sysreferences fkey2 11 False 120 True 2 5 38
Learnasp dbo sysreferences fkey3 12 False 120 True 2 5 38
Learnasp dbo sysreferences fkey4 13 False 120 True 2 5 38
Learnasp dbo sysreferences fkey5 14 False 120 True 2 5 38
Learnasp dbo sysreferences fkey6 15 False 120 True 2 5 38
Learnasp dbo sysreferences fkey7 16 False 120 True 2 5 38
Learnasp dbo sysreferences fkey8 17 False 120 True 2 5 38
Learnasp dbo sysreferences fkey9 18 False 120 True 2 5 38
Learnasp dbo sysreferences fkey10 19 False 120 True 2 5 38
Learnasp dbo sysreferences fkey11 20 False 120 True 2 5 38
Learnasp dbo sysreferences fkey12 21 False 120 True 2 5 38
Learnasp dbo sysreferences fkey13 22 False 120 True 2 5 38
Learnasp dbo sysreferences fkey14 23 False 120 True 2 5 38
Learnasp dbo sysreferences fkey15 24 False 120 True 2 5 38
Learnasp dbo sysreferences fkey16 25 False 120 True 2 5 38
Learnasp dbo sysreferences rkey1 26 False 120 True 2 5 38
Learnasp dbo sysreferences rkey2 27 False 120 True 2 5 38
Learnasp dbo sysreferences rkey3 28 False 120 True 2 5 38
Learnasp dbo sysreferences rkey4 29 False 120 True 2 5 38
Learnasp dbo sysreferences rkey5 30 False 120 True 2 5 38
Learnasp dbo sysreferences rkey6 31 False 120 True 2 5 38
Learnasp dbo sysreferences rkey7 32 False 120 True 2 5 38
Learnasp dbo sysreferences rkey8 33 False 120 True 2 5 38
Learnasp dbo sysreferences rkey9 34 False 120 True 2 5 38
Learnasp dbo sysreferences rkey10 35 False 120 True 2 5 38
Learnasp dbo sysreferences rkey11 36 False 120 True 2 5 38
Learnasp dbo sysreferences rkey12 37 False 120 True 2 5 38
Learnasp dbo sysreferences rkey13 38 False 120 True 2 5 38
Learnasp dbo sysreferences rkey14 39 False 120 True 2 5 38
Learnasp dbo sysreferences rkey15 40 False 120 True 2 5 38
Learnasp dbo sysreferences rkey16 41 False 120 True 2 5 38
Learnasp dbo syssegments segment 1 False 24 False 3 10 56
Learnasp dbo syssegments name 2 False 8 False 129 10 10 39
Learnasp dbo syssegments status 3 False 24 False 3 10 56
Learnasp dbo systypes name 1 False 8 False 130 128 256 39
Learnasp dbo systypes xtype 2 False 24 False 17 3 48
Learnasp dbo systypes status 3 False 24 False 17 3 48
Learnasp dbo systypes xusertype 4 False 24 False 2 5 52
Learnasp dbo systypes length 5 False 24 False 2 5 52
Learnasp dbo systypes xprec 6 False 24 False 17 3 48
Learnasp dbo systypes xscale 7 False 24 False 17 3 48
Learnasp dbo systypes tdefault 8 False 24 False 3 10 56
Learnasp dbo systypes domain 9 False 24 False 3 10 56
Learnasp dbo systypes uid 10 False 24 False 2 5 52
Learnasp dbo systypes reserved 11 False 24 False 2 5 52
Learnasp dbo systypes collationid 12 False 120 True 3 10 38
Learnasp dbo systypes usertype 13 False 120 True 2 5 38
Learnasp dbo systypes variable 14 False 120 True 11 50
Learnasp dbo systypes allownulls 15 False 120 True 11 50
Learnasp dbo systypes type 16 False 120 True 17 3 38
Learnasp dbo systypes printfmt 17 False 104 True 129 255 255 39
Learnasp dbo systypes prec 18 False 120 True 2 5 38
Learnasp dbo systypes scale 19 False 120 True 17 3 38
Learnasp dbo systypes collation 20 False 104 True 130 128 256 39
Learnasp dbo sysusers uid 1 False 24 False 2 5 52
Learnasp dbo sysusers status 2 False 24 False 2 5 52
Learnasp dbo sysusers name 3 False 8 False 130 128 256 39
Learnasp dbo sysusers sid 4 False 104 True 128 85 85 37
Learnasp dbo sysusers roles 5 False 8 False 128 2048 2048 37
Learnasp dbo sysusers createdate 6 False 24 False 135 9 61
Learnasp dbo sysusers updatedate 7 False 24 False 135 9 61
Learnasp dbo sysusers altuid 8 False 24 False 2 5 52
Learnasp dbo sysusers password 9 False 104 True 128 256 256 37
Learnasp dbo sysusers gid 10 False 120 True 2 5 38
Learnasp dbo sysusers environ 11 False 104 True 129 255 255 39
Learnasp dbo sysusers hasdbaccess 12 False 120 True 3 10 38
Learnasp dbo sysusers islogin 13 False 120 True 3 10 38
Learnasp dbo sysusers isntname 14 False 120 True 3 10 38
Learnasp dbo sysusers isntgroup 15 False 120 True 3 10 38
Learnasp dbo sysusers isntuser 16 False 120 True 3 10 38
Learnasp dbo sysusers issqluser 17 False 120 True 3 10 38
Learnasp dbo sysusers isaliased 18 False 120 True 3 10 38
Learnasp dbo sysusers issqlrole 19 False 120 True 3 10 38
Learnasp dbo sysusers isapprole 20 False 120 True 3 10 38
Learnasp dbo title authors ISBN 1 False 104 True 130 20 40 39
Learnasp dbo title authors Au_ID 2 False 120 True 3 10 38
Learnasp dbo Titles Title 1 False 104 True 130 255 510 39
Learnasp dbo Titles Year_ Published 2 False 120 True 2 5 38
Learnasp dbo Titles ISBN 3 False 104 True 130 20 40 39
Learnasp dbo Titles PubID 4 False 120 True 3 10 38
Learnasp dbo Titles Description 5 False 104 True 130 50 100 39
Learnasp dbo Titles Notes 6 False 104 True 130 50 100 39
Learnasp dbo Titles Subject 7 False 104 True 130 50 100 39
Learnasp dbo Titles Comments 8 False 232 True 130 1073741823 2147483646 35
Learnasp dbo titles_authors ISBN 1 False 104 True 130 20 40 39
Learnasp dbo titles_authors Au_ID 2 False 120 True 3 10 38

adSchemaCheckConstraints
is not supported

adSchemaConstraintColumnUsage
is not supported

adSchemaConstraintTableUsage
is not supported

adSchemaKeyColumnUsage
is not supported

adSchemaAsserts
is not supported

adSchemaTableConstraints
is not supported

adSchemaColumnsDomainUsage
is not supported

adSchemaIndexes
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME INDEX_CATALOG INDEX_SCHEMA INDEX_NAME PRIMARY_KEY UNIQUE CLUSTERED TYPE FILL_FACTOR INITIAL_SIZE NULLS SORT_BOOKMARKS AUTO_UPDATE NULL_COLLATION ORDINAL_POSITION COLUMN_NAME COLUMN_GUID COLUMN_PROPID COLLATION CARDINALITY PAGES FILTER_CONDITION INTEGRATED

adSchemaColumnPrivileges
GRANTOR GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_GUID COLUMN_PROPID PRIVILEGE_TYPE IS_GRANTABLE

adSchemaTablePrivileges
is not supported

adSchemaUsagePrivileges
is not supported

adSchemaProcedures
PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PROCEDURE_TYPE PROCEDURE_DEFINITION DESCRIPTION DATE_CREATED DATE_MODIFIED
Learnasp dbo dt_addtosourcecontrol;1 3
Learnasp dbo dt_addtosourcecontrol_u;1 3
Learnasp dbo dt_adduserobject;1 3
Learnasp dbo dt_adduserobject_vcs;1 3
Learnasp dbo dt_checkinobject;1 3
Learnasp dbo dt_checkinobject_u;1 3
Learnasp dbo dt_checkoutobject;1 3
Learnasp dbo dt_checkoutobject_u;1 3
Learnasp dbo dt_displayoaerror;1 3
Learnasp dbo dt_displayoaerror_u;1 3
Learnasp dbo dt_droppropertiesbyid;1 3
Learnasp dbo dt_dropuserobjectbyid;1 3
Learnasp dbo dt_generateansiname;1 3
Learnasp dbo dt_getobjwithprop;1 3
Learnasp dbo dt_getobjwithprop_u;1 3
Learnasp dbo dt_getpropertiesbyid;1 3
Learnasp dbo dt_getpropertiesbyid_u;1 3
Learnasp dbo dt_getpropertiesbyid_vcs;1 3
Learnasp dbo dt_getpropertiesbyid_vcs_u;1 3
Learnasp dbo dt_isundersourcecontrol;1 3
Learnasp dbo dt_isundersourcecontrol_u;1 3
Learnasp dbo dt_removefromsourcecontrol;1 3
Learnasp dbo dt_setpropertybyid;1 3
Learnasp dbo dt_setpropertybyid_u;1 3
Learnasp dbo dt_validateloginparams;1 3
Learnasp dbo dt_validateloginparams_u;1 3
Learnasp dbo dt_vcsenabled;1 3
Learnasp dbo dt_verstamp006;1 3
Learnasp dbo dt_verstamp007;1 3
Learnasp dbo dt_whocheckedout;1 3
Learnasp dbo dt_whocheckedout_u;1 3
Learnasp dbo GetDistinctColumn;1 3
Learnasp dbo GetDistinctColumnandCount;1 3
Learnasp dbo GetDistinctColumnCount;1 3
Learnasp dbo GetDistinctState;1 3
Learnasp dbo GetFolders;1 3
Learnasp dbo SearchCSZ;1 3

adSchemaSchemata
CATALOG_NAME SCHEMA_NAME SCHEMA_OWNER DEFAULT_CHARACTER_SET_CATALOG DEFAULT_CHARACTER_SET_SCHEMA DEFAULT_CHARACTER_SET_NAME
dbo

adSchemaSQLLanguages
is not supported

adSchemaStatistics
is not supported

adSchemaTables
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE TABLE_GUID DESCRIPTION TABLE_PROPID DATE_CREATED DATE_MODIFIED
Learnasp dbo syscolumns SYSTEM TABLE
Learnasp dbo syscomments SYSTEM TABLE
Learnasp dbo sysdepends SYSTEM TABLE
Learnasp dbo sysfilegroups SYSTEM TABLE
Learnasp dbo sysfiles SYSTEM TABLE
Learnasp dbo sysfiles1 SYSTEM TABLE
Learnasp dbo sysforeignkeys SYSTEM TABLE
Learnasp dbo sysfulltextcatalogs SYSTEM TABLE
Learnasp dbo sysfulltextnotify SYSTEM TABLE
Learnasp dbo sysindexes SYSTEM TABLE
Learnasp dbo sysindexkeys SYSTEM TABLE
Learnasp dbo sysmembers SYSTEM TABLE
Learnasp dbo sysobjects SYSTEM TABLE
Learnasp dbo syspermissions SYSTEM TABLE
Learnasp dbo sysproperties SYSTEM TABLE
Learnasp dbo sysprotects SYSTEM TABLE
Learnasp dbo sysreferences SYSTEM TABLE
Learnasp dbo systypes SYSTEM TABLE
Learnasp dbo sysusers SYSTEM TABLE
Learnasp dbo Authors TABLE
Learnasp dbo dtproperties TABLE
Learnasp dbo junk_NotFound TABLE
Learnasp dbo NFlog TABLE
Learnasp dbo NFLogDetails TABLE
Learnasp dbo NFLogQueryDetails TABLE
Learnasp dbo NFredirects TABLE
Learnasp dbo publishers TABLE
Learnasp dbo PublishersNew TABLE
Learnasp dbo title authors TABLE
Learnasp dbo Titles TABLE
Learnasp dbo titles_authors TABLE
Learnasp dbo sysconstraints VIEW
Learnasp dbo syssegments VIEW

adSchemaTranslations
is not supported

adSchemaProviderTypes
TYPE_NAME DATA_TYPE COLUMN_SIZE LITERAL_PREFIX LITERAL_SUFFIX CREATE_PARAMS IS_NULLABLE CASE_SENSITIVE SEARCHABLE UNSIGNED_ATTRIBUTE FIXED_PREC_SCALE AUTO_UNIQUE_VALUE LOCAL_TYPE_NAME MINIMUM_SCALE MAXIMUM_SCALE GUID TYPELIB VERSION IS_LONG BEST_MATCH IS_FIXEDLENGTH
sql_variant 128 8000 True False 3 False sql_variant False
uniqueidentifier 72 36 ' ' True False 3 False uniqueidentifier False True
ntext 130 1073741823 N' ' True False 2 False ntext True False
nvarchar 130 4000 N' ' max length True False 4 False nvarchar False False
sysname 130 128 N' ' False False 4 False sysname False False
nchar 130 4000 N' ' length True False 4 False nchar False True
bit 11 1 True False 3 False bit False True
tinyint 17 3 True False 3 True True False tinyint 0 0 False True
tinyint identity 17 3 False False 3 True True True tinyint identity 0 0 False True
bigint 20 19 True False 3 False True False bigint 0 0 False True
bigint identity 20 19 False False 3 False True True bigint identity 0 0 False True
image 128 2147483647 0x True False 1 False image True False
varbinary 128 8000 0x max length True False 3 False varbinary False False
binary 128 8000 0x length True False 3 False binary False True
timestamp 128 8 0x False False 3 False timestamp False True
text 129 2147483647 ' ' True False 2 False text True False
char 129 8000 ' ' length True False 4 False char False True
numeric 131 38 precision,scale True False 3 False True False numeric 0 38 False True
numeric() identity 131 38 precision False False 3 False True True numeric() identity 0 0 False True
decimal 131 38 precision,scale True False 3 False True False decimal 0 38 False True
money 6 19 $ True False 3 False True False money False True
smallmoney 6 10 $ True False 3 False True False smallmoney False True
decimal() identity 131 38 precision False False 3 False True True decimal() identity 0 0 False True
int 3 10 True False 3 False True False int 0 0 False True
int identity 3 10 False False 3 False True True int identity 0 0 False True
smallint 2 5 True False 3 False True False smallint 0 0 False True
smallint identity 2 5 False False 3 False True True smallint identity 0 0 False True
float 5 15 True False 3 False True False float False True
real 4 7 True False 3 False True False real False True
datetime 135 23 ' ' True False 4 False datetime False True
smalldatetime 135 16 ' ' True False 4 False smalldatetime False True
varchar 129 8000 ' ' max length True False 4 False varchar False False

adSchemaViews
is not supported

adSchemaViewColumnUsage
is not supported

adSchemaViewTableUsage
is not supported

adSchemaProcedureParameters
PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME ORDINAL_POSITION PARAMETER_TYPE PARAMETER_HASDEFAULT PARAMETER_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DESCRIPTION TYPE_NAME LOCAL_TYPE_NAME SS_DATA_TYPE
Learnasp dbo dt_addtosourcecontrol;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_addtosourcecontrol;1 @vchSourceSafeINI 1 1 True 129 255 255 varchar 39
Learnasp dbo dt_addtosourcecontrol;1 @vchProjectName 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_addtosourcecontrol;1 @vchComment 3 1 True 129 255 255 varchar 39
Learnasp dbo dt_addtosourcecontrol;1 @vchLoginName 4 1 True 129 255 255 varchar 39
Learnasp dbo dt_addtosourcecontrol;1 @vchPassword 5 1 True 129 255 255 varchar 39
Learnasp dbo dt_addtosourcecontrol_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_addtosourcecontrol_u;1 @vchSourceSafeINI 1 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_addtosourcecontrol_u;1 @vchProjectName 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_addtosourcecontrol_u;1 @vchComment 3 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_addtosourcecontrol_u;1 @vchLoginName 4 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_addtosourcecontrol_u;1 @vchPassword 5 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_adduserobject;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_adduserobject_vcs;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_adduserobject_vcs;1 @vchProperty 1 1 True 129 64 64 varchar 39
Learnasp dbo dt_checkinobject;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_checkinobject;1 @chObjectType 1 1 True 129 4 4 char 39
Learnasp dbo dt_checkinobject;1 @vchObjectName 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkinobject;1 @vchComment 3 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkinobject;1 @vchLoginName 4 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkinobject;1 @vchPassword 5 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkinobject;1 @iVCSFlags 6 1 True 3 10 int 38
Learnasp dbo dt_checkinobject;1 @iActionFlag 7 1 True 3 10 int 38
Learnasp dbo dt_checkinobject;1 @txStream1 8 1 True 129 2147483647 2147483647 text 35
Learnasp dbo dt_checkinobject;1 @txStream2 9 1 True 129 2147483647 2147483647 text 35
Learnasp dbo dt_checkinobject;1 @txStream3 10 1 True 129 2147483647 2147483647 text 35
Learnasp dbo dt_checkinobject_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_checkinobject_u;1 @chObjectType 1 1 True 129 4 4 char 39
Learnasp dbo dt_checkinobject_u;1 @vchObjectName 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkinobject_u;1 @vchComment 3 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkinobject_u;1 @vchLoginName 4 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkinobject_u;1 @vchPassword 5 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkinobject_u;1 @iVCSFlags 6 1 True 3 10 int 38
Learnasp dbo dt_checkinobject_u;1 @iActionFlag 7 1 True 3 10 int 38
Learnasp dbo dt_checkinobject_u;1 @txStream1 8 1 True 129 2147483647 2147483647 text 35
Learnasp dbo dt_checkinobject_u;1 @txStream2 9 1 True 129 2147483647 2147483647 text 35
Learnasp dbo dt_checkinobject_u;1 @txStream3 10 1 True 129 2147483647 2147483647 text 35
Learnasp dbo dt_checkoutobject;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_checkoutobject;1 @chObjectType 1 1 True 129 4 4 char 39
Learnasp dbo dt_checkoutobject;1 @vchObjectName 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkoutobject;1 @vchComment 3 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkoutobject;1 @vchLoginName 4 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkoutobject;1 @vchPassword 5 1 True 129 255 255 varchar 39
Learnasp dbo dt_checkoutobject;1 @iVCSFlags 6 1 True 3 10 int 38
Learnasp dbo dt_checkoutobject;1 @iActionFlag 7 1 True 3 10 int 38
Learnasp dbo dt_checkoutobject_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_checkoutobject_u;1 @chObjectType 1 1 True 129 4 4 char 39
Learnasp dbo dt_checkoutobject_u;1 @vchObjectName 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkoutobject_u;1 @vchComment 3 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkoutobject_u;1 @vchLoginName 4 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkoutobject_u;1 @vchPassword 5 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_checkoutobject_u;1 @iVCSFlags 6 1 True 3 10 int 38
Learnasp dbo dt_checkoutobject_u;1 @iActionFlag 7 1 True 3 10 int 38
Learnasp dbo dt_displayoaerror;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_displayoaerror;1 @iObject 1 1 True 3 10 int 38
Learnasp dbo dt_displayoaerror;1 @iresult 2 1 True 3 10 int 38
Learnasp dbo dt_displayoaerror_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_displayoaerror_u;1 @iObject 1 1 True 3 10 int 38
Learnasp dbo dt_displayoaerror_u;1 @iresult 2 1 True 3 10 int 38
Learnasp dbo dt_droppropertiesbyid;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_droppropertiesbyid;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_droppropertiesbyid;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_dropuserobjectbyid;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_dropuserobjectbyid;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_generateansiname;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_generateansiname;1 @name 1 2 True 129 255 255 varchar 39
Learnasp dbo dt_getobjwithprop;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_getobjwithprop;1 @property 1 1 True 129 30 30 varchar 39
Learnasp dbo dt_getobjwithprop;1 @value 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_getobjwithprop_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_getobjwithprop_u;1 @property 1 1 True 129 30 30 varchar 39
Learnasp dbo dt_getobjwithprop_u;1 @uvalue 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_getpropertiesbyid;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_getpropertiesbyid;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_getpropertiesbyid;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_getpropertiesbyid_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_getpropertiesbyid_u;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_getpropertiesbyid_u;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_getpropertiesbyid_vcs;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_getpropertiesbyid_vcs;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_getpropertiesbyid_vcs;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_getpropertiesbyid_vcs;1 @value 3 2 True 129 255 255 varchar 39
Learnasp dbo dt_getpropertiesbyid_vcs_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_getpropertiesbyid_vcs_u;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_getpropertiesbyid_vcs_u;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_getpropertiesbyid_vcs_u;1 @value 3 2 True 130 255 510 nvarchar 39
Learnasp dbo dt_isundersourcecontrol;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_isundersourcecontrol;1 @vchLoginName 1 1 True 129 255 255 varchar 39
Learnasp dbo dt_isundersourcecontrol;1 @vchPassword 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_isundersourcecontrol;1 @iWhoToo 3 1 True 3 10 int 38
Learnasp dbo dt_isundersourcecontrol_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_isundersourcecontrol_u;1 @vchLoginName 1 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_isundersourcecontrol_u;1 @vchPassword 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_isundersourcecontrol_u;1 @iWhoToo 3 1 True 3 10 int 38
Learnasp dbo dt_removefromsourcecontrol;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_setpropertybyid;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_setpropertybyid;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_setpropertybyid;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_setpropertybyid;1 @value 3 1 True 129 255 255 varchar 39
Learnasp dbo dt_setpropertybyid;1 @lvalue 4 1 True 128 2147483647 2147483647 image 34
Learnasp dbo dt_setpropertybyid_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_setpropertybyid_u;1 @id 1 1 True 3 10 int 38
Learnasp dbo dt_setpropertybyid_u;1 @property 2 1 True 129 64 64 varchar 39
Learnasp dbo dt_setpropertybyid_u;1 @uvalue 3 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_setpropertybyid_u;1 @lvalue 4 1 True 128 2147483647 2147483647 image 34
Learnasp dbo dt_validateloginparams;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_validateloginparams;1 @vchLoginName 1 1 True 129 255 255 varchar 39
Learnasp dbo dt_validateloginparams;1 @vchPassword 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_validateloginparams_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_validateloginparams_u;1 @vchLoginName 1 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_validateloginparams_u;1 @vchPassword 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_vcsenabled;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_verstamp006;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_verstamp007;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_whocheckedout;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_whocheckedout;1 @chObjectType 1 1 True 129 4 4 char 39
Learnasp dbo dt_whocheckedout;1 @vchObjectName 2 1 True 129 255 255 varchar 39
Learnasp dbo dt_whocheckedout;1 @vchLoginName 3 1 True 129 255 255 varchar 39
Learnasp dbo dt_whocheckedout;1 @vchPassword 4 1 True 129 255 255 varchar 39
Learnasp dbo dt_whocheckedout_u;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo dt_whocheckedout_u;1 @chObjectType 1 1 True 129 4 4 char 39
Learnasp dbo dt_whocheckedout_u;1 @vchObjectName 2 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_whocheckedout_u;1 @vchLoginName 3 1 True 130 255 510 nvarchar 39
Learnasp dbo dt_whocheckedout_u;1 @vchPassword 4 1 True 130 255 510 nvarchar 39
Learnasp dbo GetDistinctColumn;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo GetDistinctColumn;1 @selcol 1 1 True 129 25 25 varchar 39
Learnasp dbo GetDistinctColumnandCount;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo GetDistinctColumnandCount;1 @selcol 1 1 True 129 25 25 varchar 39
Learnasp dbo GetDistinctColumnandCount;1 @colcount 2 2 True 3 10 int 38
Learnasp dbo GetDistinctColumnCount;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo GetDistinctColumnCount;1 @selcol 1 1 True 129 25 25 varchar 39
Learnasp dbo GetDistinctState;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo GetFolders;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo SearchCSZ;1 @RETURN_VALUE 0 4 False 3 10 int 56
Learnasp dbo SearchCSZ;1 @city 1 1 True 129 25 25 varchar 39
Learnasp dbo SearchCSZ;1 @state 2 1 True 129 5 5 varchar 39
Learnasp dbo SearchCSZ;1 @zip 3 1 True 129 10 10 varchar 39

adSchemaForeignKeys
PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME PK_COLUMN_NAME PK_COLUMN_GUID PK_COLUMN_PROPID FK_TABLE_CATALOG FK_TABLE_SCHEMA FK_TABLE_NAME FK_COLUMN_NAME FK_COLUMN_GUID FK_COLUMN_PROPID ORDINAL UPDATE_RULE DELETE_RULE PK_NAME FK_NAME DEFERRABILITY

adSchemaPrimaryKeys
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_GUID COLUMN_PROPID ORDINAL PK_NAME

adSchemaProcedureColumns
is not supported

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	COLUMN_GUID	COLUMN_PROPID	ORDINAL_POSITION	COLUMN_HASDEFAULT	COLUMN_DEFAULT	COLUMN_FLAGS	IS_NULLABLE	DATA_TYPE	TYPE_GUID	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	DATETIME_PRECISION	CHARACTER_SET_CATALOG	CHARACTER_SET_SCHEMA	CHARACTER_SET_NAME	COLLATION_CATALOG	COLLATION_SCHEMA	COLLATION_NAME	DOMAIN_CATALOG	DOMAIN_SCHEMA	DOMAIN_NAME	DESCRIPTION	SS_DATA_TYPE
Learnasp	dbo	Authors	Au_ID			1	False		24	False	3				10													56
Learnasp	dbo	Authors	Author			2	False		104	True	130		50	100														39
Learnasp	dbo	Authors	Year_ Born			3	False		120	True	2				5													38
Learnasp	dbo	dtproperties	id			1	False		24	False	3				10													56
Learnasp	dbo	dtproperties	objectid			2	False		120	True	3				10													38
Learnasp	dbo	dtproperties	property			3	False		8	False	129		64	64														39
Learnasp	dbo	dtproperties	value			4	False		104	True	129		255	255														39
Learnasp	dbo	dtproperties	uvalue			5	False		104	True	130		255	510														39
Learnasp	dbo	dtproperties	lvalue			6	False		232	True	128		2147483647	2147483647														34
Learnasp	dbo	dtproperties	version			7	True	(0)	24	False	3				10													56
Learnasp	dbo	junk_NotFound	keyNotFound			1	False		24	False	3				10													56
Learnasp	dbo	junk_NotFound	RequestUriStem			2	False		8	False	129		200	200														39
Learnasp	dbo	junk_NotFound	NumRequests			3	True	(1)	24	False	3				10													56
Learnasp	dbo	junk_NotFound	LastRequestDate			4	True	(getdate())	120	True	135						9											111
Learnasp	dbo	junk_NotFound	RedirectUriStem			5	False		104	True	129		200	200														39
Learnasp	dbo	NFlog	NFLogKey			1	False		24	False	3				10													56
Learnasp	dbo	NFlog	URL			2	False		8	False	129		200	200														39
Learnasp	dbo	NFlog	NumRequests			3	False		120	True	3				10													38
Learnasp	dbo	NFlog	NumRequestsCorrected			4	True	(0)	120	True	3				10													38
Learnasp	dbo	NFlog	LastRequest			5	True	(getdate())	120	True	135						9											111
Learnasp	dbo	NFlog	LogDetails			6	True	(1)	120	True	11																	50
Learnasp	dbo	NFlog	Ignore			7	True	(0)	120	True	11																	50
Learnasp	dbo	NFLogDetails	NFLogDetails			1	False		24	False	3				10													56
Learnasp	dbo	NFLogDetails	NFLogKey			2	False		120	True	3				10													38
Learnasp	dbo	NFLogDetails	Key_NFLogQueryDetails			3	False		120	True	3				10													38
Learnasp	dbo	NFLogDetails	When			4	True	(getdate())	120	True	135						9											111
Learnasp	dbo	NFLogDetails	URL			5	False		104	True	129		200	200														39
Learnasp	dbo	NFLogDetails	QueryString			6	False		104	True	129		200	200														39
Learnasp	dbo	NFLogDetails	Referrer			7	False		104	True	129		300	300														39
Learnasp	dbo	NFLogDetails	UserAgent			8	False		104	True	129		300	300														39
Learnasp	dbo	NFLogDetails	UserHostAddress			9	False		104	True	129		50	50														39
Learnasp	dbo	NFLogDetails	UserHostName			10	False		104	True	129		100	100														39
Learnasp	dbo	NFLogQueryDetails	NFLogQueryDetails			1	False		24	False	3				10													56
Learnasp	dbo	NFLogQueryDetails	URL			2	False		104	True	129		200	200														39
Learnasp	dbo	NFLogQueryDetails	QueryString			3	False		104	True	129		200	200														39
Learnasp	dbo	NFLogQueryDetails	Referrer			4	False		104	True	129		300	300														39
Learnasp	dbo	NFLogQueryDetails	UserAgent			5	False		104	True	129		300	300														39
Learnasp	dbo	NFLogQueryDetails	UserHostAddress			6	False		104	True	129		50	50														39
Learnasp	dbo	NFLogQueryDetails	UserHostName			7	False		104	True	129		100	100														39
Learnasp	dbo	NFLogQueryDetails	Checksum			8	False		8	False	129		64	64														39
Learnasp	dbo	NFredirects	NFredirectskey			1	False		24	False	3				10													56
Learnasp	dbo	NFredirects	URL			2	False		104	True	129		100	100														39
Learnasp	dbo	NFredirects	URLNew			3	False		104	True	129		200	200														39
Learnasp	dbo	publishers	PubID			1	False		24	False	3				10													56
Learnasp	dbo	publishers	Name			2	False		104	True	130		50	100														39
Learnasp	dbo	publishers	Company Name			3	False		104	True	130		255	510														39
Learnasp	dbo	publishers	Address			4	False		104	True	130		50	100														39
Learnasp	dbo	publishers	City			5	False		104	True	130		20	40														39
Learnasp	dbo	publishers	State			6	False		104	True	130		10	20														39
Learnasp	dbo	publishers	Zip			7	False		104	True	130		15	30														39
Learnasp	dbo	publishers	Telephone			8	False		104	True	130		15	30														39
Learnasp	dbo	publishers	Fax			9	False		104	True	130		15	30														39
Learnasp	dbo	publishers	Comments			10	False		232	True	130		1073741823	2147483646														35
Learnasp	dbo	PublishersNew	PubID			1	False		24	False	3				10													56
Learnasp	dbo	PublishersNew	Name			2	False		104	True	130		50	100														39
Learnasp	dbo	PublishersNew	Company Name			3	False		104	True	130		255	510														39
Learnasp	dbo	PublishersNew	Address			4	False		104	True	130		50	100														39
Learnasp	dbo	PublishersNew	City			5	False		104	True	130		20	40														39
Learnasp	dbo	PublishersNew	State			6	False		104	True	130		10	20														39
Learnasp	dbo	PublishersNew	Zip			7	False		104	True	130		15	30														39
Learnasp	dbo	PublishersNew	Telephone			8	False		104	True	130		15	30														39
Learnasp	dbo	PublishersNew	Fax			9	False		104	True	130		15	30														39
Learnasp	dbo	PublishersNew	Comments			10	False		232	True	130		1073741823	2147483646														35
Learnasp	dbo	syscolumns	name			1	False		8	False	130		128	256														39
Learnasp	dbo	syscolumns	id			2	False		24	False	3				10													56
Learnasp	dbo	syscolumns	xtype			3	False		24	False	17				3													48
Learnasp	dbo	syscolumns	typestat			4	False		24	False	17				3													48
Learnasp	dbo	syscolumns	xusertype			5	False		24	False	2				5													52
Learnasp	dbo	syscolumns	length			6	False		24	False	2				5													52
Learnasp	dbo	syscolumns	xprec			7	False		24	False	17				3													48
Learnasp	dbo	syscolumns	xscale			8	False		24	False	17				3													48
Learnasp	dbo	syscolumns	colid			9	False		24	False	2				5													52
Learnasp	dbo	syscolumns	xoffset			10	False		24	False	2				5													52
Learnasp	dbo	syscolumns	bitpos			11	False		24	False	17				3													48
Learnasp	dbo	syscolumns	reserved			12	False		24	False	17				3													48
Learnasp	dbo	syscolumns	colstat			13	False		24	False	2				5													52
Learnasp	dbo	syscolumns	cdefault			14	False		24	False	3				10													56
Learnasp	dbo	syscolumns	domain			15	False		24	False	3				10													56
Learnasp	dbo	syscolumns	number			16	False		24	False	2				5													52
Learnasp	dbo	syscolumns	colorder			17	False		24	False	2				5													52
Learnasp	dbo	syscolumns	autoval			18	False		104	True	128		8000	8000														37
Learnasp	dbo	syscolumns	offset			19	False		24	False	2				5													52
Learnasp	dbo	syscolumns	collationid			20	False		120	True	3				10													38
Learnasp	dbo	syscolumns	language			21	False		24	False	3				10													56
Learnasp	dbo	syscolumns	status			22	False		120	True	17				3													38
Learnasp	dbo	syscolumns	type			23	False		120	True	17				3													38
Learnasp	dbo	syscolumns	usertype			24	False		120	True	2				5													38
Learnasp	dbo	syscolumns	printfmt			25	False		104	True	129		255	255														39
Learnasp	dbo	syscolumns	prec			26	False		120	True	2				5													38
Learnasp	dbo	syscolumns	scale			27	False		120	True	3				10													38
Learnasp	dbo	syscolumns	iscomputed			28	False		120	True	3				10													38
Learnasp	dbo	syscolumns	isoutparam			29	False		120	True	3				10													38
Learnasp	dbo	syscolumns	isnullable			30	False		120	True	3				10													38
Learnasp	dbo	syscolumns	collation			31	False		104	True	130		128	256														39
Learnasp	dbo	syscolumns	tdscollation			32	False		120	True	128		5	5														37
Learnasp	dbo	syscomments	id			1	False		24	False	3				10													56
Learnasp	dbo	syscomments	number			2	False		24	False	2				5													52
Learnasp	dbo	syscomments	colid			3	False		24	False	2				5													52
Learnasp	dbo	syscomments	status			4	False		24	False	2				5													52
Learnasp	dbo	syscomments	ctext			5	False		8	False	128		8000	8000														37
Learnasp	dbo	syscomments	texttype			6	False		120	True	2				5													38
Learnasp	dbo	syscomments	language			7	False		120	True	2				5													38
Learnasp	dbo	syscomments	encrypted			8	False		120	True	11																	50
Learnasp	dbo	syscomments	compressed			9	False		120	True	11																	50
Learnasp	dbo	syscomments	text			10	False		104	True	130		4000	8000														39
Learnasp	dbo	sysconstraints	constid			1	False		120	True	3				10													38
Learnasp	dbo	sysconstraints	id			2	False		120	True	3				10													38
Learnasp	dbo	sysconstraints	colid			3	False		120	True	2				5													38
Learnasp	dbo	sysconstraints	spare1			4	False		120	True	17				3													38
Learnasp	dbo	sysconstraints	status			5	False		120	True	3				10													38
Learnasp	dbo	sysconstraints	actions			6	False		120	True	3				10													38
Learnasp	dbo	sysconstraints	error			7	False		120	True	3				10													38
Learnasp	dbo	sysdepends	id			1	False		24	False	3				10													56
Learnasp	dbo	sysdepends	depid			2	False		24	False	3				10													56
Learnasp	dbo	sysdepends	number			3	False		24	False	2				5													52
Learnasp	dbo	sysdepends	depnumber			4	False		24	False	2				5													52
Learnasp	dbo	sysdepends	status			5	False		24	False	2				5													52
Learnasp	dbo	sysdepends	deptype			6	False		24	False	17				3													48
Learnasp	dbo	sysdepends	depdbid			7	False		120	True	2				5													38
Learnasp	dbo	sysdepends	depsiteid			8	False		120	True	2				5													38
Learnasp	dbo	sysdepends	selall			9	False		120	True	11																	50
Learnasp	dbo	sysdepends	resultobj			10	False		120	True	11																	50
Learnasp	dbo	sysdepends	readobj			11	False		120	True	11																	50
Learnasp	dbo	sysfilegroups	groupid			1	False		24	False	2				5													52
Learnasp	dbo	sysfilegroups	allocpolicy			2	False		24	False	2				5													52
Learnasp	dbo	sysfilegroups	status			3	False		24	False	3				10													56
Learnasp	dbo	sysfilegroups	groupname			4	False		8	False	130		128	256														39
Learnasp	dbo	sysfiles	fileid			1	False		24	False	2				5													52
Learnasp	dbo	sysfiles	groupid			2	False		24	False	2				5													52
Learnasp	dbo	sysfiles	size			3	False		24	False	3				10													56
Learnasp	dbo	sysfiles	maxsize			4	False		24	False	3				10													56
Learnasp	dbo	sysfiles	growth			5	False		24	False	3				10													56
Learnasp	dbo	sysfiles	status			6	False		24	False	3				10													56
Learnasp	dbo	sysfiles	perf			7	False		24	False	3				10													56
Learnasp	dbo	sysfiles	name			8	False		24	False	130		128	256														47
Learnasp	dbo	sysfiles	filename			9	False		24	False	130		260	520														47
Learnasp	dbo	sysfiles1	status			1	False		24	False	3				10													56
Learnasp	dbo	sysfiles1	fileid			2	False		24	False	2				5													52
Learnasp	dbo	sysfiles1	name			3	False		24	False	130		128	256														47
Learnasp	dbo	sysfiles1	filename			4	False		24	False	130		260	520														47
Learnasp	dbo	sysforeignkeys	constid			1	False		24	False	3				10													56
Learnasp	dbo	sysforeignkeys	fkeyid			2	False		24	False	3				10													56
Learnasp	dbo	sysforeignkeys	rkeyid			3	False		24	False	3				10													56
Learnasp	dbo	sysforeignkeys	fkey			4	False		24	False	2				5													52
Learnasp	dbo	sysforeignkeys	rkey			5	False		24	False	2				5													52
Learnasp	dbo	sysforeignkeys	keyno			6	False		24	False	2				5													52
Learnasp	dbo	sysfulltextcatalogs	ftcatid			1	False		24	False	2				5													52
Learnasp	dbo	sysfulltextcatalogs	name			2	False		8	False	130		128	256														39
Learnasp	dbo	sysfulltextcatalogs	status			3	False		24	False	2				5													52
Learnasp	dbo	sysfulltextcatalogs	path			4	False		104	True	130		260	520														39
Learnasp	dbo	sysfulltextnotify	tableid			1	False		24	False	3				10													56
Learnasp	dbo	sysfulltextnotify	rowinfo			2	False		24	False	2				5													52
Learnasp	dbo	sysfulltextnotify	ftkey			3	False		8	False	128		896	896														37
Learnasp	dbo	sysindexes	id			1	False		24	False	3				10													56
Learnasp	dbo	sysindexes	status			2	False		24	False	3				10													56
Learnasp	dbo	sysindexes	first			3	False		24	False	128		6	6														45
Learnasp	dbo	sysindexes	indid			4	False		24	False	2				5													52
Learnasp	dbo	sysindexes	root			5	False		24	False	128		6	6														45
Learnasp	dbo	sysindexes	minlen			6	False		24	False	2				5													52
Learnasp	dbo	sysindexes	keycnt			7	False		24	False	2				5													52
Learnasp	dbo	sysindexes	groupid			8	False		24	False	2				5													52
Learnasp	dbo	sysindexes	dpages			9	False		24	False	3				10													56
Learnasp	dbo	sysindexes	reserved			10	False		24	False	3				10													56
Learnasp	dbo	sysindexes	used			11	False		24	False	3				10													56
Learnasp	dbo	sysindexes	rowcnt			12	False		24	False	20				19													63
Learnasp	dbo	sysindexes	rowmodctr			13	False		24	False	3				10													56
Learnasp	dbo	sysindexes	reserved3			14	False		24	False	17				3													48
Learnasp	dbo	sysindexes	reserved4			15	False		24	False	17				3													48
Learnasp	dbo	sysindexes	xmaxlen			16	False		24	False	2				5													52
Learnasp	dbo	sysindexes	maxirow			17	False		24	False	2				5													52
Learnasp	dbo	sysindexes	OrigFillFactor			18	False		24	False	17				3													48
Learnasp	dbo	sysindexes	StatVersion			19	False		24	False	17				3													48
Learnasp	dbo	sysindexes	reserved2			20	False		24	False	3				10													56
Learnasp	dbo	sysindexes	FirstIAM			21	False		24	False	128		6	6														45
Learnasp	dbo	sysindexes	impid			22	False		24	False	2				5													52
Learnasp	dbo	sysindexes	lockflags			23	False		24	False	2				5													52
Learnasp	dbo	sysindexes	pgmodctr			24	False		24	False	3				10													56
Learnasp	dbo	sysindexes	keys			25	False		104	True	128		1088	1088														37
Learnasp	dbo	sysindexes	name			26	False		8	False	130		128	256														39
Learnasp	dbo	sysindexes	statblob			27	False		232	True	128		2147483647	2147483647														34
Learnasp	dbo	sysindexes	maxlen			28	False		24	False	3				10													56
Learnasp	dbo	sysindexes	rows			29	False		120	True	3				10													38
Learnasp	dbo	sysindexkeys	id			1	False		24	False	3				10													56
Learnasp	dbo	sysindexkeys	indid			2	False		24	False	2				5													52
Learnasp	dbo	sysindexkeys	colid			3	False		24	False	2				5													52
Learnasp	dbo	sysindexkeys	keyno			4	False		24	False	2				5													52
Learnasp	dbo	sysmembers	memberuid			1	False		24	False	2				5													52
Learnasp	dbo	sysmembers	groupuid			2	False		24	False	2				5													52
Learnasp	dbo	sysobjects	name			1	False		8	False	130		128	256														39
Learnasp	dbo	sysobjects	id			2	False		24	False	3				10													56
Learnasp	dbo	sysobjects	xtype			3	False		24	False	129		2	2														47
Learnasp	dbo	sysobjects	uid			4	False		24	False	2				5													52
Learnasp	dbo	sysobjects	info			5	False		24	False	2				5													52
Learnasp	dbo	sysobjects	status			6	False		24	False	3				10													56
Learnasp	dbo	sysobjects	base_schema_ver			7	False		24	False	3				10													56
Learnasp	dbo	sysobjects	replinfo			8	False		24	False	3				10													56
Learnasp	dbo	sysobjects	parent_obj			9	False		24	False	3				10													56
Learnasp	dbo	sysobjects	crdate			10	False		24	False	135						9											61
Learnasp	dbo	sysobjects	ftcatid			11	False		24	False	2				5													52
Learnasp	dbo	sysobjects	schema_ver			12	False		24	False	3				10													56
Learnasp	dbo	sysobjects	stats_schema_ver			13	False		24	False	3				10													56
Learnasp	dbo	sysobjects	type			14	False		120	True	129		2	2														39
Learnasp	dbo	sysobjects	userstat			15	False		120	True	2				5													38
Learnasp	dbo	sysobjects	sysstat			16	False		120	True	2				5													38
Learnasp	dbo	sysobjects	indexdel			17	False		120	True	2				5													38
Learnasp	dbo	sysobjects	refdate			18	False		120	True	135						9											111
Learnasp	dbo	sysobjects	version			19	False		120	True	3				10													38
Learnasp	dbo	sysobjects	deltrig			20	False		120	True	3				10													38
Learnasp	dbo	sysobjects	instrig			21	False		120	True	3				10													38
Learnasp	dbo	sysobjects	updtrig			22	False		120	True	3				10													38
Learnasp	dbo	sysobjects	seltrig			23	False		120	True	3				10													38
Learnasp	dbo	sysobjects	category			24	False		120	True	3				10													38
Learnasp	dbo	sysobjects	cache			25	False		120	True	2				5													38
Learnasp	dbo	syspermissions	id			1	False		24	False	3				10													56
Learnasp	dbo	syspermissions	grantee			2	False		24	False	2				5													52
Learnasp	dbo	syspermissions	grantor			3	False		24	False	2				5													52
Learnasp	dbo	syspermissions	actadd			4	False		24	False	2				5													52
Learnasp	dbo	syspermissions	actmod			5	False		24	False	2				5													52
Learnasp	dbo	syspermissions	seladd			6	False		104	True	128		4000	4000														37
Learnasp	dbo	syspermissions	selmod			7	False		104	True	128		4000	4000														37
Learnasp	dbo	syspermissions	updadd			8	False		104	True	128		4000	4000														37
Learnasp	dbo	syspermissions	updmod			9	False		104	True	128		4000	4000														37
Learnasp	dbo	syspermissions	refadd			10	False		104	True	128		4000	4000														37
Learnasp	dbo	syspermissions	refmod			11	False		104	True	128		4000	4000														37
Learnasp	dbo	sysproperties	id			1	False		24	False	3				10													56
Learnasp	dbo	sysproperties	smallid			2	False		24	False	2				5													52
Learnasp	dbo	sysproperties	type			3	False		24	False	17				3													48
Learnasp	dbo	sysproperties	name			4	False		8	False	130		128	256														39
Learnasp	dbo	sysproperties	value			5	False		120	True	128		0	8000														39
Learnasp	dbo	sysprotects	id			1	False		24	False	3				10													56
Learnasp	dbo	sysprotects	uid			2	False		24	False	2				5													52
Learnasp	dbo	sysprotects	action			3	False		24	False	17				3													48
Learnasp	dbo	sysprotects	protecttype			4	False		24	False	17				3													48
Learnasp	dbo	sysprotects	columns			5	False		104	True	128		4000	4000														37
Learnasp	dbo	sysprotects	grantor			6	False		24	False	2				5													52
Learnasp	dbo	sysreferences	constid			1	False		24	False	3				10													56
Learnasp	dbo	sysreferences	fkeyid			2	False		24	False	3				10													56
Learnasp	dbo	sysreferences	rkeyid			3	False		24	False	3				10													56
Learnasp	dbo	sysreferences	rkeyindid			4	False		24	False	2				5													52
Learnasp	dbo	sysreferences	keycnt			5	False		24	False	2				5													52
Learnasp	dbo	sysreferences	forkeys			6	False		8	False	128		32	32														37
Learnasp	dbo	sysreferences	refkeys			7	False		8	False	128		32	32														37
Learnasp	dbo	sysreferences	fkeydbid			8	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkeydbid			9	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey1			10	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey2			11	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey3			12	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey4			13	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey5			14	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey6			15	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey7			16	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey8			17	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey9			18	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey10			19	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey11			20	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey12			21	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey13			22	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey14			23	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey15			24	False		120	True	2				5													38
Learnasp	dbo	sysreferences	fkey16			25	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey1			26	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey2			27	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey3			28	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey4			29	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey5			30	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey6			31	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey7			32	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey8			33	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey9			34	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey10			35	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey11			36	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey12			37	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey13			38	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey14			39	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey15			40	False		120	True	2				5													38
Learnasp	dbo	sysreferences	rkey16			41	False		120	True	2				5													38
Learnasp	dbo	syssegments	segment			1	False		24	False	3				10													56
Learnasp	dbo	syssegments	name			2	False		8	False	129		10	10														39
Learnasp	dbo	syssegments	status			3	False		24	False	3				10													56
Learnasp	dbo	systypes	name			1	False		8	False	130		128	256														39
Learnasp	dbo	systypes	xtype			2	False		24	False	17				3													48
Learnasp	dbo	systypes	status			3	False		24	False	17				3													48
Learnasp	dbo	systypes	xusertype			4	False		24	False	2				5													52
Learnasp	dbo	systypes	length			5	False		24	False	2				5													52
Learnasp	dbo	systypes	xprec			6	False		24	False	17				3													48
Learnasp	dbo	systypes	xscale			7	False		24	False	17				3													48
Learnasp	dbo	systypes	tdefault			8	False		24	False	3				10													56
Learnasp	dbo	systypes	domain			9	False		24	False	3				10													56
Learnasp	dbo	systypes	uid			10	False		24	False	2				5													52
Learnasp	dbo	systypes	reserved			11	False		24	False	2				5													52
Learnasp	dbo	systypes	collationid			12	False		120	True	3				10													38
Learnasp	dbo	systypes	usertype			13	False		120	True	2				5													38
Learnasp	dbo	systypes	variable			14	False		120	True	11																	50
Learnasp	dbo	systypes	allownulls			15	False		120	True	11																	50
Learnasp	dbo	systypes	type			16	False		120	True	17				3													38
Learnasp	dbo	systypes	printfmt			17	False		104	True	129		255	255														39
Learnasp	dbo	systypes	prec			18	False		120	True	2				5													38
Learnasp	dbo	systypes	scale			19	False		120	True	17				3													38
Learnasp	dbo	systypes	collation			20	False		104	True	130		128	256														39
Learnasp	dbo	sysusers	uid			1	False		24	False	2				5													52
Learnasp	dbo	sysusers	status			2	False		24	False	2				5													52
Learnasp	dbo	sysusers	name			3	False		8	False	130		128	256														39
Learnasp	dbo	sysusers	sid			4	False		104	True	128		85	85														37
Learnasp	dbo	sysusers	roles			5	False		8	False	128		2048	2048														37
Learnasp	dbo	sysusers	createdate			6	False		24	False	135						9											61
Learnasp	dbo	sysusers	updatedate			7	False		24	False	135						9											61
Learnasp	dbo	sysusers	altuid			8	False		24	False	2				5													52
Learnasp	dbo	sysusers	password			9	False		104	True	128		256	256														37
Learnasp	dbo	sysusers	gid			10	False		120	True	2				5													38
Learnasp	dbo	sysusers	environ			11	False		104	True	129		255	255														39
Learnasp	dbo	sysusers	hasdbaccess			12	False		120	True	3				10													38
Learnasp	dbo	sysusers	islogin			13	False		120	True	3				10													38
Learnasp	dbo	sysusers	isntname			14	False		120	True	3				10													38
Learnasp	dbo	sysusers	isntgroup			15	False		120	True	3				10													38
Learnasp	dbo	sysusers	isntuser			16	False		120	True	3				10													38
Learnasp	dbo	sysusers	issqluser			17	False		120	True	3				10													38
Learnasp	dbo	sysusers	isaliased			18	False		120	True	3				10													38
Learnasp	dbo	sysusers	issqlrole			19	False		120	True	3				10													38
Learnasp	dbo	sysusers	isapprole			20	False		120	True	3				10													38
Learnasp	dbo	title authors	ISBN			1	False		104	True	130		20	40														39
Learnasp	dbo	title authors	Au_ID			2	False		120	True	3				10													38
Learnasp	dbo	Titles	Title			1	False		104	True	130		255	510														39
Learnasp	dbo	Titles	Year_ Published			2	False		120	True	2				5													38
Learnasp	dbo	Titles	ISBN			3	False		104	True	130		20	40														39
Learnasp	dbo	Titles	PubID			4	False		120	True	3				10													38
Learnasp	dbo	Titles	Description			5	False		104	True	130		50	100														39
Learnasp	dbo	Titles	Notes			6	False		104	True	130		50	100														39
Learnasp	dbo	Titles	Subject			7	False		104	True	130		50	100														39
Learnasp	dbo	Titles	Comments			8	False		232	True	130		1073741823	2147483646														35
Learnasp	dbo	titles_authors	ISBN			1	False		104	True	130		20	40														39
Learnasp	dbo	titles_authors	Au_ID			2	False		120	True	3				10													38

PROCEDURE_CATALOG	PROCEDURE_SCHEMA	PROCEDURE_NAME	PROCEDURE_TYPE	PROCEDURE_DEFINITION	DESCRIPTION	DATE_CREATED	DATE_MODIFIED
Learnasp	dbo	dt_addtosourcecontrol;1	3
Learnasp	dbo	dt_addtosourcecontrol_u;1	3
Learnasp	dbo	dt_adduserobject;1	3
Learnasp	dbo	dt_adduserobject_vcs;1	3
Learnasp	dbo	dt_checkinobject;1	3
Learnasp	dbo	dt_checkinobject_u;1	3
Learnasp	dbo	dt_checkoutobject;1	3
Learnasp	dbo	dt_checkoutobject_u;1	3
Learnasp	dbo	dt_displayoaerror;1	3
Learnasp	dbo	dt_displayoaerror_u;1	3
Learnasp	dbo	dt_droppropertiesbyid;1	3
Learnasp	dbo	dt_dropuserobjectbyid;1	3
Learnasp	dbo	dt_generateansiname;1	3
Learnasp	dbo	dt_getobjwithprop;1	3
Learnasp	dbo	dt_getobjwithprop_u;1	3
Learnasp	dbo	dt_getpropertiesbyid;1	3
Learnasp	dbo	dt_getpropertiesbyid_u;1	3
Learnasp	dbo	dt_getpropertiesbyid_vcs;1	3
Learnasp	dbo	dt_getpropertiesbyid_vcs_u;1	3
Learnasp	dbo	dt_isundersourcecontrol;1	3
Learnasp	dbo	dt_isundersourcecontrol_u;1	3
Learnasp	dbo	dt_removefromsourcecontrol;1	3
Learnasp	dbo	dt_setpropertybyid;1	3
Learnasp	dbo	dt_setpropertybyid_u;1	3
Learnasp	dbo	dt_validateloginparams;1	3
Learnasp	dbo	dt_validateloginparams_u;1	3
Learnasp	dbo	dt_vcsenabled;1	3
Learnasp	dbo	dt_verstamp006;1	3
Learnasp	dbo	dt_verstamp007;1	3
Learnasp	dbo	dt_whocheckedout;1	3
Learnasp	dbo	dt_whocheckedout_u;1	3
Learnasp	dbo	GetDistinctColumn;1	3
Learnasp	dbo	GetDistinctColumnandCount;1	3
Learnasp	dbo	GetDistinctColumnCount;1	3
Learnasp	dbo	GetDistinctState;1	3
Learnasp	dbo	GetFolders;1	3
Learnasp	dbo	SearchCSZ;1	3

CATALOG_NAME	SCHEMA_NAME	SCHEMA_OWNER	DEFAULT_CHARACTER_SET_CATALOG	DEFAULT_CHARACTER_SET_SCHEMA	DEFAULT_CHARACTER_SET_NAME
	dbo