# 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]

#### See also

List of Tables