Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

How to find tables without Indexes?

Add comment
Views: 79
Votes: 0
Comments: 0
Run following query in Query Editor.

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
Others in this Category
document Q: What are various constraints used in SQL?
document What is Data Compression?
document What is NOLOCK?
document Q: What is difference between UNIQUE and PRIMARY KEY constraints?
document What are the difference between clustered and a non-clustered index?
document Q: Can a view be updated/inserted/deleted? If Yes under what conditions ?
document What is an execution plan? When would you use it? How would you view the execution plan?
document What is FOREIGN KEY?
document What are the basic functions for master, msdb, model, tempdb and resource databases?
document What do you mean by Table Sample?
» More articles



RSS