Description
Bicycle assembly diagrams.
Table properties
| name | value |
|---|
| name | [Production].[Illustration] |
| created | Mar 19 2009 9:08PM |
| modified | Mar 19 2009 9:08PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 5 |
| Size of data | 184 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 2,147,483,658 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| IllustrationID | int identity(1,1) | 10 | 4 | | no
| yes
| |
| no
| Primary key for Illustration records.
|
| Diagram | xml | max | 2147483646 | | yes
|
| |
| no
| Illustrations used in manufacturing instructions. Stored as XML.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
| name | description | column | comment |
|---|
| PK_Illustration_IllustrationID | clustered, unique, primary key located on PRIMARY | IllustrationID | Clustered index created by a primary key constraint.
|
Referenced by
Foreign key graph
Defaults
Dependency graph
Sample rows
| IllustrationID | Diagram | ModifiedDate |
|---|
| 3
| <!-- Generator: Adobe Illustrator 10.0, SVG Export Plug-In . SVG Version: 3.0.0 Build 76) --><svg x...
| 2/10/2004 1:06:11 PM
|
| 4
| <!-- Generator: Adobe Illustrator 10.0, SVG Export Plug-In . SVG Version: 3.0.0 Build 76) --><svg x...
| 2/10/2004 1:06:11 PM
|
| 5
| <!-- Generator: Adobe Illustrator 10.0, SVG Export Plug-In . SVG Version: 3.0.0 Build 76) --><svg x...
| 2/10/2004 1:06:11 PM
|
| 6
| <!-- Generator: Adobe Illustrator 10.0, SVG Export Plug-In . SVG Version: 3.0.0 Build 76) --><svg x...
| 2/10/2004 1:06:12 PM
|
| 7
| <!-- Generator: Adobe Illustrator 10.0, SVG Export Plug-In . SVG Version: 3.0.0 Build 76) --><svg x...
| 2/10/2004 1:06:12 PM
|
Code
CREATE TABLE [Production].[Illustration](
[IllustrationID] [int] IDENTITY(1,1) NOT NULL,
[Diagram] [xml] NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_Illustration_IllustrationID] PRIMARY KEY CLUSTERED
(
[IllustrationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [Production].[Illustration] ADD CONSTRAINT [DF_Illustration_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]