Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Why I can't execute select objectid([tableName]) ?

Author  Topic 

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2004-10-22 : 20:11:05


I know this querry "select objectid([TableAidaLou])" will return if that table exist.
But why this error occurs as a try to execute the statement?...

Server: Msg 195, Level 15, State 10, Line 1
'objectid' is not a recognized function name.

Is this function available - "objectid" ?




Want Philippines to become 1st World COuntry? Go for World War 3...

bmanoj
Starting Member

13 Posts

Posted - 2004-10-22 : 22:33:19
select object_id('TableAidaLou')

Manoj
Go to Top of Page

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2004-10-22 : 23:08:03
bmanoj gee thnx!

Such my mistake on me...

Want Philippines to become 1st World COuntry? Go for World War 3...
Go to Top of Page
   

- Advertisement -