Table overview
| name | created | columns | rows | indexes | triggers | constraints | refers to | refers from | dependents | row size | data | indexes | comment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dbo.authors | Feb 10 2007 4:32PM | 9 | 23 | 2 | 0 | 1 | 0 | 2 | 3 | 167 b | 6 kb | 2 kb | |
| dbo.blurbs | Feb 10 2007 4:32PM | 2 | 6 | 0 | 0 | 1 | 1 | 0 | 0 | 11 b | 16 kb | 2 kb | |
| dbo.discounts | Feb 10 2007 4:32PM | 5 | 4 | 0 | 0 | 1 | 1 | 0 | 1 | 56 b | 2 kb | 2 kb | |
| dbo.my_new_publishers | Mar 10 2007 10:39PM | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 66 b | 2 kb | 2 kb | |
| dbo.publishers | Feb 10 2007 4:32PM | 4 | 3 | 1 | 0 | 1 | 0 | 1 | 1 | 66 b | 4 kb | 2 kb | |
| dbo.roysched | Feb 10 2007 4:32PM | 4 | 87 | 1 | 0 | 1 | 1 | 0 | 1 | 18 b | 6 kb | 2 kb | |
| dbo.sales | Feb 10 2007 4:32PM | 3 | 29 | 1 | 0 | 2 | 1 | 1 | 3 | 16 b | 4 kb | 2 kb | |
| dbo.salesdetail | Feb 10 2007 4:32PM | 5 | 116 | 2 | 1 | 3 | 3 | 0 | 6 | 24 b | 8 kb | 2 kb | |
| dbo.store_employees | Feb 10 2007 4:32PM | 11 | 61 | 1 | 0 | 3 | 2 | 0 | 1 | 182 b | 10 kb | 8 kb | |
| dbo.stores | Feb 10 2007 4:32PM | 8 | 7 | 1 | 0 | 1 | 0 | 4 | 3 | 140 b | 4 kb | 2 kb | |
| dbo.testing_foreign_key | Mar 30 2007 8:37PM | 3 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 12 b | 2 kb | 2 kb | |
| dbo.testing_primary_key | Mar 30 2007 7:14PM | 3 | 0 | 1 | 0 | 2 | 0 | 2 | 1 | 12 b | 4 kb | 2 kb | |
| dbo.titleauthor | Feb 10 2007 4:32PM | 4 | 25 | 2 | 1 | 2 | 2 | 0 | 5 | 22 b | 6 kb | 2 kb | |
| dbo.titles | Feb 10 2007 4:32PM | 10 | 18 | 2 | 1 | 2 | 1 | 3 | 8 | 329 b | 8 kb | 4 kb |
Tables referenced by views, procedures, or functions
| name | references |
|---|---|
| dbo.authors | 1 |
| dbo.discounts | 1 |
| dbo.sales | 2 |
| dbo.salesdetail | 2 |
| dbo.stores | 2 |
| dbo.titleauthor | 2 |
| dbo.titles | 4 |
Tables not referenced by views, procedures, or functions
| name |
|---|
| dbo.blurbs |
| dbo.my_new_publishers |
| dbo.publishers |
| dbo.roysched |
| dbo.store_employees |
| dbo.testing_foreign_key |
| dbo.testing_primary_key |
