Datatype: AccountNumber Datatype: AccountNumber| Property | Value |
|---|---|
| Name | AccountNumber |
| ID | 257 |
| Schema | dbo |
| Owner | dbo |
| User Defined |
|
| Native Datatype | nvarchar(15) |
| Max Length (in bytes) | 30 |
| Nullable |
|
| Is Assembly Type |
|
| Is Table Type |
|
| Name | Value |
|---|---|
| MS_Description | mobi czwartek - AccountNumber |
| Column Name | Object Name | Description | ANSI Padded | Is Rowguidcol | Is Identity | Is Computed | Is Filestream | Is Replicated | Is Non Sql Subscribed | Is Merge Published | Is DTS Replicated | Is Xml Document | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AccountNumber | Purchasing.Vendor | Vendor account (identification) number. |
|
|
|
|
|
|
|
|
|
|
|
|
| AccountNumber | Sales.SalesOrderHeader | Financial accounting number reference. |
|
|
|
|
|
|
|
|
|
|
|
|
| Script |
|---|
| CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi czwartek - AccountNumber' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'AccountNumber' |