# Table: TestProduct

## Properties

Property | Value
--- | ---
Name | TestProduct
ID | 1303675692
Owner | dbo
Schema | dbo
Filegroup | PRIMARY
Data Size (KB) | 16 KB
Index Size (KB) | 8 KB
Rows | 10
Unused (KB) | 56 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/8/2011 6:19:14 PM
Create Date | 2/8/2011 6:19:14 PM

## Extended Properties

No extended properties defined.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | Name | Name |  |  |
2 | ProductNumber | nvarchar(25) |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

No primary key constraints defined.

## Primary Key Columns

No primary key columns defined.

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

No default constraints defined.

## Indexes

No table indexes defined.

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

## Objects that depend on [TestProduct]

- dbo.TestProduct

## Objects on which [TestProduct] depends

- dbo.TestProduct
  - dbo.Name

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[TestProduct]( [Name] [dbo].[Name] NOT NULL, [ProductNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY]

#### See also

List of Tables