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) + ']; ...

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 ...