Getting the CREATE INDEX statement is as simple as adding in one more column, shown below, to this query which then generates the T-SQL CREATE INDEX statement. 'USE [' + DB_NAME(c.database_id) + ']; ...

Creates indexes on columns in tables. Restriction: You cannot use CREATE INDEX on a table accessed via an engine that does not support UPDATE processing. an IN subquery where the column in the inner ...

If indexes are defined on columns in the table, CREATE INDEX statements for those indexes are also written to the SAS log. When you are transferring a table to a DBMS that is supported by SAS/ACCESS ...