Hi All,
The following code is used to find the Table Names and Schema name without Indexes of the table.
USE <database_name>
GO
SELECT SCHEMA_NAME(schema_id) AS schema_name,name AS table_name FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0
ORDER BY schema_name, table_name;
GO
Thanks & Regards,
Sarav.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|