where can I find the database schema?

Feb 15, 2007 7 Replies

and further info about what happens when a transaction occurs?



I downloaded the sdk but didnt' see much in there regarding this. Anyone know?



Thanks


Hi

Not sure you can, w/o the customisation guide - which is a closely guarded secret. If you are a strong database person the best thing to do is to run SQL Profiler that comes with SQL Server 2000. It will log pretty well everything that happens. You still will have to figure out the schema yourself but you will see what is going into what tables.

JPH

For a simple listing of tables, try: SELECT * FROM INFORMATION_SCHEMA.TABLES

For more details about exactly which tables are used to store transaction data, you are likely on your own.

Tom

Here is a Table and Column Schema I found.

Marc

begin 666 SO Table and Column Schema.zip M4$L#!!0````(`'MXA"[K@````4T\@5&%B;&4@86YD($-O M;'5M;B!38VAE;6$N8W-VI5U9&"/+3\ZZ]O] MMCLZ9R-[..SXT=7P>=^VBG3.-VS?CO_Y'R=5U>^[L>F>CJ[.CZY[^?/RY'I] M21'B#19[;E1]_6HS"(O_S%PUPVO*TSF',^LJ;U"WH7((9*-+NQZ;MD/H_- M:/Y.P,X$KTMPYZQWW)1`)4]S(]6[S\:S!,?:_GEO_'Q>[Y$OBM:)Z:CK4G6\7#:R:>

M^']==2-_XB)5I0?!NH%5T(^?]]M'",-JLG_0!/>\ MYGS+ZW2B:S:,7W8P]FI\.&H8KA0UC5!C_XD!Q&B-S3Y=L93"QFNES6F4ZN8'WM52E65:JJ!27W6TDC1\:P;5Q$RWG_7# M>+OYK>_K#/":'=@/=@#V%0%!@G.-63\WNQU8O^F6)+639MN];&HMRK[J:B8L74."A`O6IN)[Q,92MX:-@KIQ40J35?.P#?XU,'1]QS[MX'7_9BR\8W2!F=,,-&.F&&CW3"#"/IA!E.?OK]3'#UZV2361WJX]'Z%_KNDQ9&Y$+HQ&0% ZUE_%;VS^RULZH MX68\Q0H_52[1NM^,/YC@7UG;U.I33H]%"7+:+$J0L4#B!!G+(TX06QQ[(7A7 M(4M72\#6NY9V\5JI_47W2$6)SLH!)0Z*)@RZ#K7$Z[YBR!GE7 `EO:JK3_?C M"(,X;J!+Q(`ISD//=UH?(DT4]&5EB7CBE[5 M5Q\WY3OD8KMK^P-/-?ZR$0.^.^JR)PF@]M8G&K1POR@B)O*E M_2[\XHF>P7F^% T3/-+4&6%PJ2L+FS@P--6BK':!-*F!#XY M3Z"3S>BXZ;ML3\FZ',3(G+*RZI2RC_RB3_E&FEQHV>HT(#?D[_FN914'M9W% M?N./NO0,SS +R4>LJV=>[Y$CY$D_4GDHS9I,?=9W0_/4*7,?K>E9RX9X9W*F M9(:(`+,'IL+234;;CT2 M30`25GWXGE$$`,$=TBQ5F6GO5@15MO?';6?\\"0*'7=S-J'G%I[-258 V@X!_99B"N>=5WlS^9CR!@+Z5N^K#$^U>X:;$U@$._W+=M5%BYS!&#".9+&^0OEDN/BIS2^ #U%^SVD",IAC_T96"X,BN-H&;7 M\MN-BD40\]5+,*.+"[CHZN&J*\E@I25IT#4O@E._%JC$@G4M@B\:`],""PWRCK4MN&E1T$Z] M\"WH4 ,L%1$#CPGE:>D57*)VV>G)@RO7[_(:N:[BL1U?DBJV@$M21>Y.-,^* MY:8ZX&^L&2][H5R9RE) >#4D7C*.3@N4@UM2Z>/% ME3XNJ#2E=@WYYNKL/MD8`.1;`2A4L7F@=::H=4%)Z^:I8W"9%CRVB3NU)'AY M]G!9.%G$`\1>7E>"\RZ?^]_YX;%GZ/R*AN(QG_4/*JB.`26G/858\W%4T?S< M> 4V-:F0=%)4BJS_"V8A3[3L/O*$Q)*[DT2*::WR,A^=*'N.AN5&N MOQ3F^LNB7'\MS/771;FNWI4.@W?+\BT>7LO&UZIT@*V6C;!5Z1!;+1MCJ])! MMEHVRE:EPVQ5/,Y*9Q^+S\T^%I>8?::J)F:?;_SQCC7TS&[IN=G'XKXRN

Contact me and I will send you a detailed diagram with explantions of the SO and HQ Tables.

Oh, please post it, Afshin! This is something needed out there...

I appreciate your comment Jason but because this is a sensitive info that could be used by MS competitors I rather filter to whom I send this info. The info is free and I send it to any legitimate customer or reseller for free.

That makes no sense.

That's like saying the service manual for my Ford Taurus is giving away secrets to Chevy.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required