SQL Server/T-SQL Tutorial/User Role/USER ID

Check user id with user_id() function

   <source lang="sql">

4> IF (SELECT id FROM sysobjects WHERE id=OBJECT_ID("foo") 5> AND uid=USER_ID() AND type="U") > 0 6> DROP TABLE foo 7></source>