[RESOLVED] table exist or not

[xor83]

I am Working on SQL and I want to check if table exist in a database or not.
and also how can i check is specific field exist in table or not
Help plz

[Shuja Ali]

I am assuming you are using SQL Server.

To check a Table

Select count([NAME]) From SYSOBJECTS Where [NAME] = 'myTABLENAME' 

To check if a field exists in a Table

Select Count(SYSCOLUMNS.[NAME]) From SYSCOLUMNS Inner Join SYSOBJECTS On SYSCOLUMNS.ID = SYSOBJECTS.ID Where SYSOBJECTS.[NAME] = 'myTableName' And SYSCOLUMNS.[NAME] = 'ColumnName' 

[xor83]

Thanx

[Hack]

If you consider this resolved, would you please pull down the Thread Tools menu and click the Mark Thread Resolved menu item? That will let everyone know that you have your answer.

Thank you.