Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment