SQL Database supports the three-part name format database_name.[schema_name].table_or_view_name when the database_name is the current database or the database_name is tempdb and the table_or_view_name starts with #. Rebuilding a clustered index does not rebuild associated nonclustered indexes unless the keyword ALL is specified.
thanks Go to your project preferences and then go to Builders. For any index option whose value is not stored in sys.indexes, the default indicated in the argument definition of the option applies.If ALL is specified and the underlying table is a heap, the rebuild operation has no effect on the table.Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service. Index names must be unique within a table or view but do not have to be unique within a database. ALL Specifies all indexes associated with the table or view regardless of the index type.