Options
BUG: Code analysis raises PE002 warning when creating an index on a temp table
Jacco
Posts: 11 Bronze 1
in SQL Prompt
The PE0002 warning (Schema name for table or view is not specified) is raised when creating an index on a temp table. It is (correctly) not raised when selecting from a temp table.
Repro:
CREATE TABLE #t (i INT NOT NULL);
SELECT * FROM #t;
CREATE CLUSTERED INDEX ix_t ON #t(i);
Repro:
CREATE TABLE #t (i INT NOT NULL);
SELECT * FROM #t;
CREATE CLUSTERED INDEX ix_t ON #t(i);
Tagged:
Comments
Thank you for reporting this issue.
I've reported it under this ticket: SP-6738.
Regards,
Fabiola