SQL CODE BANK
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
‹
›
Home
View web version
No comments:
Post a Comment