Check if table exists in database or not using VB.Net in ASP.Net

Hi,

Please refer below code.

SQL

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'CSE') AND type in (N'U'))
BEGIN
   DROP TABLE CSE
END

 also refer below link

http://stackoverflow.com/questions/25162815/how-to-check-if-a-database-and-tables-exist-in-sql-server-in-a-vb-net-project

Hi,

Please refer below code.

VB

cmd = New SqlCommand(@"IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'CSE') AND type in (N'U'))
                        BEGIN
                        DROP TABLE "+name+ @";
                        END", con)