Share via


SqlDataDictionary Class

The SqlDataDictionary class provides a collection of methods for data dictionary maintenance.

Syntax

class SqlDataDictionary extends Object

Run On

Server

Methods

  Method Description
Gg957750.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif indexCreate Creates the indexes of an Microsoft Dynamics AX table in the SQL database. You can also use this method to re-create indexes.
Gg957750.pubmethod(en-us,AX.60).gif indexCreateDDL Generates and returns the SQL statements needed to create the indexes of an Microsoft Dynamics AX table.
Gg957750.pubmethod(en-us,AX.60).gif indexDrop Drops the indexes of an Microsoft Dynamics AX table in the SQL database.
Gg957750.pubmethod(en-us,AX.60).gif name Translates any object name into a valid SQL database object-name; that is, valid for the database currently connected.
Gg957750.pubmethod(en-us,AX.60).gif new Initializes a new instance of the SqlDataDictionary class. (Overrides the new Method.)
Gg957750.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif tableCreate Creates one or more Microsoft Dynamics AX tables in the SQL database. Also, provides an option to create for index.
Gg957750.pubmethod(en-us,AX.60).gif tableCreateDDL Generates and returns the SQL statement to create an Microsoft Dynamics AX table.
Gg957750.pubmethod(en-us,AX.60).gif tableDelete Deletes the Microsoft Dynamics AX table in the SQL database.
Gg957750.pubmethod(en-us,AX.60).gif tableDrop Drops the Microsoft Dynamics AX table in the SQL database.
Gg957750.pubmethod(en-us,AX.60).gif tableDropDDL Generates and returns the SQL statement to drop an Microsoft Dynamics AX table.
Gg957750.pubmethod(en-us,AX.60).gif tableEmpty Returns true if table is not empty; otherwise false.
Gg957750.pubmethod(en-us,AX.60).gif tableExist Returns true if table exists; otherwise false.
Gg957750.pubmethod(en-us,AX.60).gif tableMetaData Fills the SqlDescribe table with data dictionary meta data.
Gg957750.pubmethod(en-us,AX.60).gif tableReindex Updates index for the table.
Gg957750.pubmethod(en-us,AX.60).gif tableSynchronize Synchronizes the Microsoft Dynamics AX table and the table of the SQL database.
Gg957750.pubmethod(en-us,AX.60).gif tableTruncate Truncates the Microsoft Dynamics AX table.
Gg957750.pubmethod(en-us,AX.60).gif tableTruncateDDL Generates and returns a SQL statement to truncate an Microsoft Dynamics AX table.
Gg957750.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif usageCount Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif xml Returns an XML string that represents the current object. (Inherited from Object.)
Gg957750.pubmethod(en-us,AX.60).gif Gg957750.static(en-us,AX.60).gif ::synchronize Synchronizes the Microsoft Dynamics AX data dictionary and the data dictionary of the SQL database.

Top

Remarks

This API has a built-in authorization check that is invoked at run time. Calls to members of the SQLDataDictionary class by users without access to the development security key (SysDevelopment) results in an exception.

Examples

The following example checks whether the UserInfo table exists in the database.

server static public void Main(Args _args) 
{ 
    SqlDataDictionary sqlDict; 
    boolean b; 
  
    sqlDict = new SqlDataDictionary(); 
    if (sqlDict) 
    { 
        b = sqlDict.tableExist("USERINFO"); 
        print b; 
        pause; 
    } 
}

Inheritance Hierarchy

Object Class
  SqlDataDictionary Class

See Also

Dictionary Class