SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
Thursday, January 2, 2014
To check the identity valid for the particular table
SELECT
TABLE_NAME
,
IDENT_INCR
(
TABLE_NAME
)
AS
IDENT_INCR
FROM
INFORMATION_SCHEMA
.
TABLES
WHERE
IDENT_INCR
(
TABLE_NAME
)
IS
NOT
NULL
and
TABLE_NAME
=
'??'
sp_help
?? ??
--Tablename
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment