Tables Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Tables Editor lets you manage columns, basic properties, indexes, and constraints for a table and view space usage details.

To edit a table

  1. Open an editor on the table. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Columns

Displays the currently defined columns in the table. Optionally, you can:

Select a column, and in the Property/Value list modify property values for that column.

Click Add Column, provide a name for the new column, and set property values for the column.

Select a column and click Delete to remove the column from the table.

Properties

Lets you work with settings in the following categories:

Physical Storage

Lets you view the Partitioned, Text Image Filegroup, and FileStream On (.version 2008^) properties and modify the Filegroup property. For details on these properties, see Tables (SQL Server) - Properties.

Full-Text Index

Lets you view whether Full-Text Indexing is installed and active. The full-text index feature provides support for sophisticated word searches in character string data. A full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words. This feature is available for Microsoft SQL Server 8.0 or later.

Text In Row

Lets you enable Text In Row Data and specify a limit.

Filetable (Version 2012^)

Lets you view the As Filetable, Filetable Collate Filename, FiletablePK Constraint Name, Filetable StreamID Unique Constraint Name, and Filetable Fullpath Unique Constraint Name properties and lets you modify the Filetable Directory Name property. For details on these properties, see Tables (SQL Server) - Properties. This group also lets you modify an Enabled property. That control specifies whether system-defined constraints are enabled.

Indexes

Displays any indexes currently defined for the table. Optionally, you can:

Click Add to open an Index editor, letting you create a new index for this table. For more information, see Indexes Wizard (SQL Server).

Select an index and click Edit to open an wizard that lets you modify that index. For more information, see Indexes Editor (SQL Server).

Select an index and click Drop to open a dialog that lets you confirm that you want to drop the index. When dropping an index with the Clustered option enabled, the confirmation dialog includes an Online option that lets you specify an online drop (ONLINE-ON clause).

Constraints

Lets you manage constraints for the table. Constraints are grouped by type, under folders. Optionally take one of the following actions:

Select a constraint type folder and click Add to open a dialog that lets you add a constraint of that type.

Select a constraint and click Edit to open a dialog that lets you modify the constraint details.

Select a constraint and click Drop to open a dialog that lets you confirm that you want to drop the index. When dropping a clustered unique key or clustered primary key, the confirmation dialog includes an Online option that lets you specify an online drop (ONLINE-ON clause).

Space

Lets you view pie charts showing the space usage for the table. Optionally you can double-click a slice in the pie chart for detailed statistics.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.