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