Table: Globally_Unique_Data

Properties

Property	Value
Name	Globally_Unique_Data
ID	999674609
Owner	dbo
Schema	dbo
Filegroup	PRIMARY
Data Size (KB)	0 KB
Index Size (KB)	0 KB
Rows	0
Unused (KB)	0 KB
ANSI Null On
Quoted Identifier
Lock Escalation	TABLE
Lock On Bulk Load
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data
Text In Row Limit (bytes)	Option not set
Large Value Types Out Of Row
FullText Change Tracking On
Tracked By Cdc
Published
Schema Published
Replicated
Replication Filter
Merge Published
Sync Tran Subscribed
MS Shipped
Modify Date	2/6/2011 2:50:05 PM
Create Date	2/6/2011 2:50:05 PM

Extended Properties

No extended properties defined.

Columns

Column ID	Column Name	Datatype	Nullable	Is Sparse	Is Column Set
1	guid	uniqueidentifier
2	Employee_Name	varchar(60)

Identity Columns

No identity columns defined.

Primary Key Constraints

Name	Is System Named	Extended Property Name	Extended Property Value
Guid_PK

Primary Key Columns

Name
guid

Foreign Keys

No foreign keys defined.

Column Level Check Constraints

No column constraints defined.

Table Level Check Constraints

No table constraints defined.

Default Constraints

Name	Column	Definition	Is System Named	Extended Property Name	Extended Property Value
Guid_Default	guid	(newsequentialid())

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
Guid_PK	CLUSTERED

FullText Indexes

No fulltext indexes defined.

Referencing Tables

No referencing tables defined.

Object Level Permissions

No object level permissions defined.

Column Level Permissions

No explicit column permissions granted to this object

Statistics

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
Guid_PK

Detailed Statistics Density

No detailed statistics.

Detailed Statistics Histogram

No histogram statistics.

Objects that depend on [Globally_Unique_Data]

dbo.Globally_Unique_Data
- dbo.vw_Globally_Unique_Data

Objects on which [Globally_Unique_Data] depends

dbo.Globally_Unique_Data

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Globally_Unique_Data]( [guid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [Employee_Name] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY]