Difference between revisions of "Person (schema)"

From dbscript Online Help
Jump to: navigation, search
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
| '''schema
+
| '''Schema
| .Person
+
| Person
|-
+
|- valign="top"
 +
| '''Description
 +
| Contains objects related to names and addresses of customers, vendors, and employees
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE SCHEMA Person AUTHORIZATION dbo
 
CREATE SCHEMA Person AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Person.Address_(table)|Person.Address]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Person.ContactType_(table)|Person.ContactType]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[Person.StateProvince_(table)|Person.StateProvince]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]]
 +
 +
|- valign="top"
 +
| Schema
 +
| XML Schema Collection
 +
| [[Person.AdditionalContactInfoSchemaCollection_(xml schema collection)|Person.AdditionalContactInfoSchemaCollection]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 18: Line 77:
 
| Person
 
| Person
 
|- valign="top"
 
|- valign="top"
 
 
| '''Description
 
| '''Description
 
| Contains objects related to names and addresses of customers, vendors, and employees
 
| Contains objects related to names and addresses of customers, vendors, and employees
 
|-
 
|-
 
 
|}
 
|}
  

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

Schema Person
Description Contains objects related to names and addresses of customers, vendors, and employees

Source[edit]

CREATE SCHEMA Person AUTHORIZATION dbo

Dependencies[edit]

Reference Type Object Type Referencing Object
Schema Table Person.Address
Schema Table Person.AddressType
Schema Table Person.Contact
Schema Table Person.ContactType
Schema Table Person.CountryRegion
Schema Table Person.StateProvince
Schema View Person.vAdditionalContactInfo
Schema View Person.vStateProvinceCountryRegion
Schema XML Schema Collection Person.AdditionalContactInfoSchemaCollection


automatically generated[edit]

schema Person
Description Contains objects related to names and addresses of customers, vendors, and employees
CREATE SCHEMA Person AUTHORIZATION dbo


Reference Type Object Type Referencing Object
Schema Table Person.Address
Schema Table Person.AddressType
Schema Table Person.Contact
Schema Table Person.ContactType
Schema Table Person.CountryRegion
Schema Table Person.StateProvince
Schema View Person.vAdditionalContactInfo
Schema View Person.vStateProvinceCountryRegion
Schema XML Schema Collection Person.AdditionalContactInfoSchemaCollection