SQL CODE BANK
Search
Wednesday, July 27, 2011
Findout obeject ID of a Table
use EPTS
go
SELECT OBJECT_ID FROM sys.objects
WHERE name = 'CsssSystem'
AND SCHEMA_ID =
(SELECT SCHEMA_ID
FROM sys.schemas
WHERE name = 'dbo')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment