Skip to content

view-the-table-definition.md

Latest commit

 

History

History
73 lines (50 loc) · 2.44 KB

view-the-table-definition.md

File metadata and controls

73 lines (50 loc) · 2.44 KB
title View the Table Definition | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
dbe-tables
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
showing table properties
displaying table properties
tables [SQL Server], properties
viewing table properties
ms.assetid 1865fb7c-f480-4100-9007-df5364cd002a
caps.latest.revision 18
author BYHAM
ms.author rickbyh
manager jhubbard

View the Table Definition

[!INCLUDEtsql-appliesto-ss2016-all_md]

You can display properties for a table in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

Before You Begin

Security

Permissions

You can only see properties in a table if you either own the table or have been granted permissions to that table.

Using SQL Server Management Studio

To show table properties in the Properties window

  1. In Object Explorer, select the table for which you want to show properties.

  2. Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.

Using Transact-SQL

To show table properties

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute. The example returns all columns from the sys.tables catalog view for the specified object.

    SELECT * FROM sys.tables  
WHERE object_id = 1973582069;

For more information, see sys.tables (Transact-SQL).