Table Class

The Table object represents a Microsoft SQL Server table.

Spazio dei nomi: Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintassi

'Dichiarazione
Public NotInheritable Class Table
    Inherits TableViewBase
    Implements IColumnPermission, IObjectPermission, ICreatable, IAlterable, _
    IDroppable, IRenamable

public sealed class Table : TableViewBase, IColumnPermission, IObjectPermission, ICreatable, 
    IAlterable, IDroppable, IRenamable

public ref class Table sealed : public TableViewBase, IColumnPermission, IObjectPermission, ICreatable, 
    IAlterable, IDroppable, IRenamable

public final class Table extends TableViewBase implements IColumnPermission, IObjectPermission, 
    ICreatable, IAlterable, IDroppable, IRenamable

public final class Table extends TableViewBase implements IColumnPermission, IObjectPermission, 
    ICreatable, IAlterable, IDroppable, IRenamable

Osservazioni

Testo aggiornato:

Testo aggiornato:

Questo spazio dei nomi, classe o membro è supportato solo nella versione 2.0 di Microsoft .NET Framework.

To get Table object properties, users can be a member of the public fixed server role.

To set Table object properties, users must have ALTER permission on the table.

To create a table, users must have CREATE TABLE permission on the parent database and ALTER permission in the schema.

To drop a table, users must have CONTROL permission on the table, or be a member of the db_ddladmin or db_owner fixed database roles.

To grant, deny, or revoke permission on the table to other users, users must have CONTROL permission on the table.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.SmoObjectBase
     Microsoft.SqlServer.Management.Smo.SqlSmoObject
       Microsoft.SqlServer.Management.Smo.NamedSmoObject
         Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
           Microsoft.SqlServer.Management.Smo.ScriptSchemaObjectBase
             Microsoft.SqlServer.Management.Smo.TableViewBase
              Microsoft.SqlServer.Management.Smo.Table

Esempio

How to: Create, Alter, and Remove a Table in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

Table Members
Microsoft.SqlServer.Management.Smo Namespace

Altre risorse

Creating, Altering, and Removing Tables
Tabelle
CREATE TABLE (Transact-SQL)