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