Pages
Home
Insights
Service & Support
Consulting
Contact Us
Monday, August 12, 2013
T-SQL script to get list of tables which dont have clustered index
SELECT
name
AS
Table_Name_WithoutClusteredIndex
FROM
SYS
.
TABLES
WHERE
OBJECTPROPERTY
(
OBJECT_ID
,
'TableHasClustIndex'
)
=
0
ORDER
BY
NAME
GO
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment