Question

'm trying to verify that a SQL DATABASE is empty ,

Data/Application Integration, SQL, Database

I am modifying a VB program that is taking ALL the tables from an ACCESS Database and converting them to a SQL DATABASE.
They VB Program opens the SQL DATABASE, but I want to verify the database is completely empty. Is there a function or call that can be added to the code??

There's no function, but you can query the system and see what's in there.

SQL 7/2000
To look and see if there are any tables in the database.

SELECT *
 FROM sysobjects
 WHERE xtype = 'U'
 and name <> 'dtproperties'  /*This table is used for the database diagrams, so you don't want to delete it.*/
 

To look and see if there are any views in the database.

SELECT *
 FROM sysobjects
 WHERE Xtype = 'V'

To look and see if there are any procedures in the database.

SELECT *
 FROM sysobjects
 WHERE xtype = 'P'

SQL 2005+
To look and see if there are any tables in the database.

SELECT *
 FROM sys.tables

To look and see if there are any views in the database.

SELECT *
 FROM sys.views

To look and see if there are any procedures in the database.

SELECT *
 FROM sys.procedures