Statement Questions

Hello to all,

I know homework questions are frowned upon and am not looking for a professional to all of my work (just a bit of insight). I know they are: if, from, and where, but I have done a bit of research and am having trouble exactly defining these two questions. What is the purpose of these two statements and why are they needed?


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Employee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Employee]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Job_title]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Job_title]
GO

Thanks in advance!