stopcode.net

Dave Knipper Was Here

Retrieving Table Metadata from SQL Server in a View

The follow shows how to create a view that will retrieve table metadata from your SQL Server database. The TableMetaData view is only for tables only and not for views. Added bonus: A view that returns primary keys. Here are the results from the BlogEngine.NET SQL Server database driving this site:

Id tableName tableDescription columnName columnDescription columnTypeName columnPrecision columnScale columnLength columnIsNullable columnOrdinal isPrimaryKey isReadonlyIdentity
1E45BA3C-9286-4098-B1E0-65E90F710F8F be_BlogRollItems NULL BlogRollRowId NULL int 10 0 4 0 1 1 1
D40CCE59-5CE9-4FA6-96DB-D601B22CCE0C be_BlogRollItems NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
DD4EC103-80EA-4C60-8F82-3A932CACC607 be_BlogRollItems NULL BlogRollId NULL uniqueidentifier 0 NULL 16 0 3 0 0
9FBD4AFA-CC29-49F6-B187-98A9754BE76A be_BlogRollItems NULL Title NULL nvarchar 255 NULL 510 0 4 0 0
836D97DC-FFCE-4738-B3E4-AD38B8D20D6D be_BlogRollItems NULL Description NULL nvarchar -1 NULL -1 1 5 0 0
FE3E2423-DE7A-46F5-BB1A-F5E9E5C18A1D be_BlogRollItems NULL BlogUrl NULL varchar 255 NULL 255 0 6 0 0
9525C01A-24C7-4413-9493-ECA41706CAFB be_BlogRollItems NULL FeedUrl NULL varchar 255 NULL 255 1 7 0 0
48866BBF-07A1-40E3-8DEB-36821AD6C72E be_BlogRollItems NULL Xfn NULL varchar 255 NULL 255 1 8 0 0
D01CF00C-28CB-479B-AAA7-434E99714F22 be_BlogRollItems NULL SortIndex NULL int 10 0 4 0 9 0 0
27DC1F63-0A5C-4A49-A20A-14106C819CFC be_Blogs NULL BlogRowId NULL int 10 0 4 0 1 1 1
749D90EF-9F2B-4601-8BD8-6C86EE408E2D be_Blogs NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
3D91193A-D606-49AA-A67C-83F09BDC6E4B be_Blogs NULL BlogName NULL nvarchar 255 NULL 510 0 3 0 0
B0668A4C-ACD0-4692-AD89-80710B206A0D be_Blogs NULL Hostname NULL nvarchar 255 NULL 510 0 4 0 0
B2C28C5C-D9E4-4ECC-A7CD-194D48DC5A86 be_Blogs NULL IsAnyTextBeforeHostnameAccepted NULL bit 1 NULL 1 0 5 0 0
16230001-B75D-48CA-8817-87256702EE32 be_Blogs NULL StorageContainerName NULL nvarchar 255 NULL 510 0 6 0 0
E679A7ED-63B7-47B6-9494-51306F92B63D be_Blogs NULL VirtualPath NULL nvarchar 255 NULL 510 0 7 0 0
5B9F547C-D831-4486-86E1-0E7D74B9537D be_Blogs NULL IsPrimary NULL bit 1 NULL 1 0 8 0 0
4B6DD214-7ABF-4021-A890-1ADE86732B0A be_Blogs NULL IsActive NULL bit 1 NULL 1 0 9 0 0
35B3EF34-F565-4CF6-806F-9B13650BC1E3 be_Blogs NULL IsSiteAggregation NULL bit 1 NULL 1 0 10 0 0
0922F496-6501-4DFD-B5AC-1F92DC3548C0 be_Categories NULL CategoryRowID NULL int 10 0 4 0 1 1 1
ADE87DEA-5426-4282-A3A5-36083D275234 be_Categories NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
47AB5BE7-CD20-4491-B845-6A406FECF13B be_Categories NULL CategoryID NULL uniqueidentifier 0 NULL 16 0 3 0 0
57CB85E3-620B-47B0-B367-8C67CD64C40E be_Categories NULL CategoryName NULL nvarchar 50 NULL 100 1 4 0 0
B027781C-6087-4C49-9EC3-526E081077EC be_Categories NULL Description NULL nvarchar 200 NULL 400 1 5 0 0
BBABFC79-03A0-48E4-87C3-A35DEFCB4913 be_Categories NULL ParentID NULL uniqueidentifier 0 NULL 16 1 6 0 0
B55645E0-FB57-4556-A27E-392FEAD5E0CA be_DataStoreSettings NULL DataStoreSettingRowId NULL int 10 0 4 0 1 1 1
BBB833FA-7B8D-463E-B7BC-238753884253 be_DataStoreSettings NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
665CEC74-EB4E-4C98-B7E5-D34499C58F51 be_DataStoreSettings NULL ExtensionType NULL nvarchar 50 NULL 100 0 3 0 0
43F30536-15EB-4E86-ACBF-B3420B4974EF be_DataStoreSettings NULL ExtensionId NULL nvarchar 100 NULL 200 0 4 0 0
16546BD2-5880-4012-B50A-688FB1F4BA9C be_DataStoreSettings NULL Settings NULL nvarchar -1 NULL -1 0 5 0 0
BF18454A-8A3F-4452-98E4-1A7C97A2A5DD be_FileStoreDirectory NULL Id NULL uniqueidentifier 0 NULL 16 0 1 1 0
E1585C94-8944-4AF4-A10E-443283457765 be_FileStoreDirectory NULL ParentID NULL uniqueidentifier 0 NULL 16 1 2 0 0
B4EA29FE-0573-4551-9371-D164AB6F7A0E be_FileStoreDirectory NULL BlogID NULL uniqueidentifier 0 NULL 16 0 3 0 0
CEFC6F25-B2B3-401D-B5AD-1F99B4D8E387 be_FileStoreDirectory NULL Name NULL varchar 255 NULL 255 0 4 0 0
F6152996-F5BA-484F-BA78-6B0E0BFC4A39 be_FileStoreDirectory NULL FullPath NULL varchar 1000 NULL 1000 0 5 0 0
4F6A5752-4BE1-4179-9820-B0253672DCB4 be_FileStoreDirectory NULL CreateDate NULL datetime 23 3 8 0 6 0 0
CD9E805B-35FD-447B-818C-F3F403A10091 be_FileStoreDirectory NULL LastAccess NULL datetime 23 3 8 0 7 0 0
5640AD5E-E6D4-460E-BD0D-76B595E5E719 be_FileStoreDirectory NULL LastModify NULL datetime 23 3 8 0 8 0 0
ACECD4A7-C56B-4910-8F56-C2A7FE9E5A03 be_FileStoreFiles NULL FileID NULL uniqueidentifier 0 NULL 16 0 1 1 0
0A05BD14-9BFE-4915-974E-25835C18FC57 be_FileStoreFiles NULL ParentDirectoryID NULL uniqueidentifier 0 NULL 16 0 2 0 0
0A12FF62-32F6-4488-BB9C-BE67A4B901F4 be_FileStoreFiles NULL Name NULL varchar 255 NULL 255 0 3 0 0
9FE0CD48-504A-4718-B5A4-5BF2F641715C be_FileStoreFiles NULL FullPath NULL varchar 255 NULL 255 0 4 0 0
ACAFB515-2683-478E-BD4C-4146847862DF be_FileStoreFiles NULL Contents NULL varbinary -1 NULL -1 0 5 0 0
8E5E200E-A278-4DFF-9980-7253D797359B be_FileStoreFiles NULL Size NULL int 10 0 4 0 6 0 0
310AB86E-2F88-4B40-977D-742749D2E88F be_FileStoreFiles NULL CreateDate NULL datetime 23 3 8 0 7 0 0
0F493EF4-E2C5-4744-9CBF-FC3080984534 be_FileStoreFiles NULL LastAccess NULL datetime 23 3 8 0 8 0 0
487CCDEB-49F4-4D79-A43E-667A1ACBCB29 be_FileStoreFiles NULL LastModify NULL datetime 23 3 8 0 9 0 0
72ECA440-9F34-41F5-AE3E-CA8B1E2711D3 be_FileStoreFileThumbs NULL thumbnailId NULL uniqueidentifier 0 NULL 16 0 1 1 0
311BA1B0-D0EA-42EB-A7B1-0D681F4056B5 be_FileStoreFileThumbs NULL FileId NULL uniqueidentifier 0 NULL 16 0 2 0 0
A8BFDD7C-7CA5-484F-BE39-A7C8EEA2A820 be_FileStoreFileThumbs NULL size NULL int 10 0 4 0 3 0 0
9C1C7EFA-8EEA-44EB-9F49-472027EAC63E be_FileStoreFileThumbs NULL contents NULL varbinary -1 NULL -1 0 4 0 0
CA937651-059A-492A-8DC4-9EA2B681C5B4 be_PackageFiles NULL PackageId NULL nvarchar 128 NULL 256 0 1 1 0
6FA0404F-8A7D-4C38-90A3-680A2A8374AD be_PackageFiles NULL FileOrder NULL int 10 0 4 0 2 1 0
160D2F30-3B24-45B0-942C-2279F97A0AA2 be_PackageFiles NULL FilePath NULL nvarchar 255 NULL 510 0 3 0 0
C9040ECA-15AD-49A9-89EC-4FDBF6DE2896 be_PackageFiles NULL IsDirectory NULL bit 1 NULL 1 0 4 0 0
5575925A-75E5-42D2-A655-B706AE2B6467 be_Packages NULL PackageId NULL nvarchar 128 NULL 256 0 1 1 0
B7E11531-CCB1-4D3E-BC00-98F53A406D2C be_Packages NULL Version NULL nvarchar 128 NULL 256 0 2 0 0
4F1494FE-92FE-42F1-A586-DB385D116126 be_Pages NULL PageRowID NULL int 10 0 4 0 1 1 1
8BC8DC18-AF89-42A2-9683-FA8883F91766 be_Pages NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
D65D4198-02B2-4AB3-9C87-1BAE7B6BB06D be_Pages NULL PageID NULL uniqueidentifier 0 NULL 16 0 3 0 0
2A3CEEBE-EA9D-44A6-83C3-A66A2D6C7F8A be_Pages NULL Title NULL nvarchar 255 NULL 510 1 4 0 0
F13D7E0D-6EC2-4133-A61F-8FB05397FBA5 be_Pages NULL Description NULL nvarchar -1 NULL -1 1 5 0 0
1604D928-0EF9-4577-BDA8-3E9FD7223749 be_Pages NULL PageContent NULL nvarchar -1 NULL -1 1 6 0 0
C12D5104-D831-4A41-AF55-B6C6730007E0 be_Pages NULL Keywords NULL nvarchar -1 NULL -1 1 7 0 0
BD6A8548-C176-4D64-82E8-13DFE5B0BAB5 be_Pages NULL DateCreated NULL datetime 23 3 8 1 8 0 0
1D1A18CA-ACA1-48A9-90D7-926F1C003DB2 be_Pages NULL DateModified NULL datetime 23 3 8 1 9 0 0
FA4FA043-58FE-4DB4-BA4D-F1C3DFD92E3A be_Pages NULL IsPublished NULL bit 1 NULL 1 1 10 0 0
B30F8EF5-6A4E-44CC-B1BD-6121A1BD67D9 be_Pages NULL IsFrontPage NULL bit 1 NULL 1 1 11 0 0
2253D7C4-04BF-432D-8F8D-DFDE4ED09303 be_Pages NULL Parent NULL uniqueidentifier 0 NULL 16 1 12 0 0
3B3F5AFD-0C5E-479B-A0D4-97011E608545 be_Pages NULL ShowInList NULL bit 1 NULL 1 1 13 0 0
B3117D90-C45B-4EF0-94C1-A700B60C7F86 be_Pages NULL Slug NULL nvarchar 255 NULL 510 1 14 0 0
CCC9535E-6825-4105-BDEF-2ED022927301 be_Pages NULL IsDeleted NULL bit 1 NULL 1 0 15 0 0
FC5D549B-93D6-4E3A-98D9-23E7B65E75D2 be_PingService NULL PingServiceID NULL int 10 0 4 0 1 1 1
D6519CFE-C095-464B-A572-CC5A220163B5 be_PingService NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
9C7DBA5D-436D-41CA-91BE-1104E4D77CD7 be_PingService NULL Link NULL nvarchar 255 NULL 510 1 3 0 0
C0A0B5E7-C343-47D4-AA5E-C1829791C849 be_PostCategory NULL PostCategoryID NULL int 10 0 4 0 1 1 1
8A4589D4-378D-40D2-87EC-0D89014A8279 be_PostCategory NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
8D6733C7-6B89-4BED-BA71-97ACCF7225C8 be_PostCategory NULL PostID NULL uniqueidentifier 0 NULL 16 0 3 0 0
9EC0DDB5-D74B-49A9-9683-04A7891C9129 be_PostCategory NULL CategoryID NULL uniqueidentifier 0 NULL 16 0 4 0 0
7DBB64FD-9EDE-44E5-83C7-932171E90877 be_PostComment NULL PostCommentRowID NULL int 10 0 4 0 1 1 1
A7221EBB-D13F-4106-B063-9C23E0E0CBF4 be_PostComment NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
E1B69559-8307-4E94-B0AC-FC13CEF7C29B be_PostComment NULL PostCommentID NULL uniqueidentifier 0 NULL 16 0 3 0 0
86392E0E-E65C-4DD1-83C4-21168E723180 be_PostComment NULL PostID NULL uniqueidentifier 0 NULL 16 0 4 0 0
86100771-F171-4A04-8F5C-4E39E753F2AB be_PostComment NULL ParentCommentID NULL uniqueidentifier 0 NULL 16 0 5 0 0
C6C288C4-A5CF-4A4A-83CF-164F1E819205 be_PostComment NULL CommentDate NULL datetime 23 3 8 0 6 0 0
10EEC460-657B-4FB5-9CA1-47B2989E2B5A be_PostComment NULL Author NULL nvarchar 255 NULL 510 1 7 0 0
176227C2-EFD7-4424-ACD7-B2CAC701E915 be_PostComment NULL Email NULL nvarchar 255 NULL 510 1 8 0 0
1D57A2E8-2C82-4CBA-B8E0-87320F0F7346 be_PostComment NULL Website NULL nvarchar 255 NULL 510 1 9 0 0
CBDBB0E4-C5F3-4BB7-B41E-A23C7055776E be_PostComment NULL Comment NULL nvarchar -1 NULL -1 1 10 0 0
AD467695-E46E-4B19-A252-69D7A37A1916 be_PostComment NULL Country NULL nvarchar 255 NULL 510 1 11 0 0
9842D573-6656-4E33-A0E1-E39E271ABF65 be_PostComment NULL Ip NULL nvarchar 50 NULL 100 1 12 0 0
EEDA6F56-1CA5-4913-9194-60D3AFAD4C96 be_PostComment NULL IsApproved NULL bit 1 NULL 1 1 13 0 0
FFC992C1-3BE3-45E1-A68C-BDD0BB6D4212 be_PostComment NULL ModeratedBy NULL nvarchar 100 NULL 200 1 14 0 0
A30D54C0-AD50-4FB8-8A80-414A6E4AE0FD be_PostComment NULL Avatar NULL nvarchar 255 NULL 510 1 15 0 0
47BB177B-242F-4483-95B0-D05548143691 be_PostComment NULL IsSpam NULL bit 1 NULL 1 0 16 0 0
28F9E439-CC4D-456C-9735-213C6FEFE198 be_PostComment NULL IsDeleted NULL bit 1 NULL 1 0 17 0 0
E9F39C6C-E014-459C-BD11-9333EEAA24FA be_PostNotify NULL PostNotifyID NULL int 10 0 4 0 1 1 1
D2709E2D-3CDD-41AE-94EB-3C39BE5F3B79 be_PostNotify NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
BA8339F4-0F6A-4EA4-9675-6EDF280B0487 be_PostNotify NULL PostID NULL uniqueidentifier 0 NULL 16 0 3 0 0
C771F0B9-C83C-4244-8650-0985F6E64268 be_PostNotify NULL NotifyAddress NULL nvarchar 255 NULL 510 1 4 0 0
A7DC7293-99A6-4D83-B43D-1080C1D066CF be_Posts NULL PostRowID NULL int 10 0 4 0 1 1 1
9D4C8260-17BF-4502-B4ED-41186CF1B155 be_Posts NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
FB92C2BE-1C87-4A99-9844-91416104F2F9 be_Posts NULL PostID NULL uniqueidentifier 0 NULL 16 0 3 0 0
3C351D03-25CD-4792-9B0F-631688798C8D be_Posts NULL Title NULL nvarchar 255 NULL 510 1 4 0 0
09B32C6F-5FE7-413B-894A-AFFB74706EFD be_Posts NULL Description NULL nvarchar -1 NULL -1 1 5 0 0
EBC632E2-F50A-48E0-95C6-A3C110D6EF35 be_Posts NULL PostContent NULL nvarchar -1 NULL -1 1 6 0 0
9AC99944-A0D8-49FB-A9EB-E2F187FFF10C be_Posts NULL DateCreated NULL datetime 23 3 8 1 7 0 0
D29994AC-EEDD-4784-8D87-DC32D4A9C09F be_Posts NULL DateModified NULL datetime 23 3 8 1 8 0 0
EB2C6102-36DC-4616-919D-C789D3402001 be_Posts NULL Author NULL nvarchar 50 NULL 100 1 9 0 0
CE13AB59-DE7E-441C-9F49-4390F05F4D0F be_Posts NULL IsPublished NULL bit 1 NULL 1 1 10 0 0
82D9251D-D40F-4CB3-A622-5808A72E3E41 be_Posts NULL IsCommentEnabled NULL bit 1 NULL 1 1 11 0 0
4F2246FD-2B00-4545-B09E-41F23F721AD8 be_Posts NULL Raters NULL int 10 0 4 1 12 0 0
730035E2-32A4-465F-9285-1ED2A191A72B be_Posts NULL Rating NULL real 24 NULL 4 1 13 0 0
F56AAC39-9640-49FB-AD65-80F5D67AFA0E be_Posts NULL Slug NULL nvarchar 255 NULL 510 1 14 0 0
F78836D8-2D39-4301-A70A-08E1569E8B07 be_Posts NULL IsDeleted NULL bit 1 NULL 1 0 15 0 0
F48948C0-C533-4FFF-8972-584308F5C629 be_PostTag NULL PostTagID NULL int 10 0 4 0 1 1 1
3BD3F440-FEF7-4561-975E-C391A12D1591 be_PostTag NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
BBB21F79-3DAC-4E16-B4DC-0A07733988A0 be_PostTag NULL PostID NULL uniqueidentifier 0 NULL 16 0 3 0 0
CC969B8C-66F1-4A24-B4CD-5D6264CF3F15 be_PostTag NULL Tag NULL nvarchar 50 NULL 100 1 4 0 0
D84E2639-0873-424F-B634-DE4E367A6A1D be_Profiles NULL ProfileID NULL int 10 0 4 0 1 1 1
69C8F140-1446-4D66-BF3D-013EA4805F89 be_Profiles NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
1F4FA946-5167-413D-A393-22C291869566 be_Profiles NULL UserName NULL nvarchar 100 NULL 200 1 3 0 0
C45BEEE6-69CD-429D-B215-F322871999E2 be_Profiles NULL SettingName NULL nvarchar 200 NULL 400 1 4 0 0
3DFFF30E-2901-45E5-9B1A-8066913DE5CE be_Profiles NULL SettingValue NULL nvarchar -1 NULL -1 1 5 0 0
3DC48DF2-EA73-405A-99F5-37ECC08133D7 be_QuickNotes NULL QuickNoteID NULL int 10 0 4 0 1 1 1
B61328C2-3F0F-4704-863E-A8572FE49394 be_QuickNotes NULL NoteID NULL uniqueidentifier 0 NULL 16 0 2 0 0
B282C6FA-7351-44B3-A28A-37E147DB105F be_QuickNotes NULL BlogID NULL uniqueidentifier 0 NULL 16 0 3 0 0
03B3EF5C-EEED-4ACE-94DF-A051A735E025 be_QuickNotes NULL UserName NULL nvarchar 100 NULL 200 0 4 0 0
5DB27BD1-0ABC-4761-8C70-345F7D748A59 be_QuickNotes NULL Note NULL nvarchar -1 NULL -1 0 5 0 0
8E646BFB-A5E0-425C-BAA0-71CF25C6C69E be_QuickNotes NULL Updated NULL datetime 23 3 8 1 6 0 0
1079723E-128D-49E8-9B8C-643FE6B2C60A be_QuickSettings NULL QuickSettingID NULL int 10 0 4 0 1 1 1
F017FAB3-C3F5-43CB-A848-0A39F5BB6143 be_QuickSettings NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
F6D70F6F-A3A7-4A12-A6F5-A267166D60AB be_QuickSettings NULL UserName NULL nvarchar 100 NULL 200 0 3 0 0
590C51A9-E77B-486E-B821-F5C2F1DD44F4 be_QuickSettings NULL SettingName NULL nvarchar 255 NULL 510 0 4 0 0
2D9B83CA-D58C-485B-957A-B8DE6E5083C5 be_QuickSettings NULL SettingValue NULL nvarchar 255 NULL 510 0 5 0 0
BBE82910-8249-4A56-95DD-AF7D8DA1F072 be_Referrers NULL ReferrerRowId NULL int 10 0 4 0 1 1 1
E589766C-12B2-4BFD-93FB-EE66EADE43AB be_Referrers NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
9543895A-F3F6-4649-86FE-ACC3D1B7CE0F be_Referrers NULL ReferrerId NULL uniqueidentifier 0 NULL 16 0 3 0 0
1FFD1966-1ABF-4415-A663-FB7C333C7403 be_Referrers NULL ReferralDay NULL datetime 23 3 8 0 4 0 0
955BD5E0-4039-44E7-893C-FBB4FF705ED1 be_Referrers NULL ReferrerUrl NULL varchar 255 NULL 255 0 5 0 0
F1A7B021-72FF-40B1-A331-3345E798EE02 be_Referrers NULL ReferralCount NULL int 10 0 4 0 6 0 0
5711F6FC-1B30-400A-9C36-B179BDFF2946 be_Referrers NULL Url NULL varchar 255 NULL 255 1 7 0 0
5AB5D395-2F4F-4876-B1B5-6B91B6549C83 be_Referrers NULL IsSpam NULL bit 1 NULL 1 1 8 0 0
45DDC96B-DC55-47D8-B62A-84C37154AE36 be_RightRoles NULL RightRoleRowId NULL int 10 0 4 0 1 1 1
E5F5F462-333E-46F7-B0A0-4E68A719A177 be_RightRoles NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
7591D068-8D55-4E4C-8673-3024C6848872 be_RightRoles NULL RightName NULL nvarchar 100 NULL 200 0 3 0 0
204920B9-409B-4C3D-851C-3431525EB241 be_RightRoles NULL Role NULL nvarchar 100 NULL 200 0 4 0 0
4EE11909-59AE-4329-AFEB-3B1B8AA2F52A be_Rights NULL RightRowId NULL int 10 0 4 0 1 1 1
D52A8E73-13A5-427E-ADD1-37DFBF01634F be_Rights NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
1F2BBF8D-56C0-4CAB-B08E-78D29F4653A1 be_Rights NULL RightName NULL nvarchar 100 NULL 200 0 3 0 0
BF730AF2-3EB5-4A64-B47D-8DDDBFCDA640 be_Roles NULL RoleID NULL int 10 0 4 0 1 1 1
8AA1CE36-B533-4696-B9AE-50DBE0138326 be_Roles NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
CADA5DAB-76BC-4A5C-B3FA-E1918B731A62 be_Roles NULL Role NULL nvarchar 100 NULL 200 0 3 0 0
3B762648-A26F-4A4D-88FB-DFAED1AF1DE6 be_Settings NULL SettingRowId NULL int 10 0 4 0 1 1 1
05036EB5-5636-47D1-8306-5AF82575C7FA be_Settings NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
87EF6CFC-FADE-4276-B7A2-624FDC84E603 be_Settings NULL SettingName NULL nvarchar 50 NULL 100 0 3 0 0
00414323-2BB9-45EE-A148-86FCFE6D614E be_Settings NULL SettingValue NULL nvarchar -1 NULL -1 1 4 0 0
E084DA41-041C-4C0B-9805-948D67630218 be_StopWords NULL StopWordRowId NULL int 10 0 4 0 1 1 1
0F0E084B-4ED3-4CDA-A017-FD41B0249315 be_StopWords NULL BlogId NULL uniqueidentifier 0 NULL 16 0 2 0 0
9D9C5AEE-3510-4E0D-A257-E1655AB8B98A be_StopWords NULL StopWord NULL nvarchar 50 NULL 100 0 3 0 0
6C65B2A2-82E1-49DF-B4DE-186D13C0F47E be_UserRoles NULL UserRoleID NULL int 10 0 4 0 1 1 1
FD18F1FC-C8B5-4166-AE4E-5641497A71E2 be_UserRoles NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
2777EF32-2E82-4E4D-91C7-2DE3C8633CCD be_UserRoles NULL UserName NULL nvarchar 100 NULL 200 0 3 0 0
1C9F7A12-AF0A-441D-8BDD-2773AA249EFF be_UserRoles NULL Role NULL nvarchar 100 NULL 200 0 4 0 0
09CBE555-802B-4E8D-ABD1-A517D36F3AAB be_Users NULL UserID NULL int 10 0 4 0 1 1 1
269C7948-EA51-4EAC-904F-A932E01C7EE2 be_Users NULL BlogID NULL uniqueidentifier 0 NULL 16 0 2 0 0
6C21BE2E-8CC8-447D-9D02-9DD3D58E0BAF be_Users NULL UserName NULL nvarchar 100 NULL 200 0 3 0 0
BA2440F8-0DC8-4B77-AF1D-7671FBB964E3 be_Users NULL Password NULL nvarchar 255 NULL 510 0 4 0 0
13D0C792-487C-481C-852C-188F7C0ADF52 be_Users NULL LastLoginTime NULL datetime 23 3 8 1 5 0 0
DA1C1BA9-317C-493E-8AEA-C6408C6D070C be_Users NULL EmailAddress NULL nvarchar 100 NULL 200 1 6 0 0