Checking database has a table.

[Lost User]

This might help you:

select count(table_name) from information_schema.tables

However, some databases might not support it.

[Lost User]

yuvarajujogi wrote:

How to check whether a database has a table out of that database

Why, will it also hold tables out of "other" databases? You can check if a table exists by quering sys.tables in Sql Server. Other database-servers will have similar options.

Bastard Programmer from Hell :suss:

[RDBurmon]

It depends which database you are using. If you are using MSAccess , then you can write the code in any language and using TABLE collection you can count and note the tables name If you are using SQL SERVER , then here is querey "SELECT * FROM Sys.Tables" If you are using MySQL , then here is query SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]

[PIEBALDconsult]

Yet another way to get a list of tables in an ADO.net-supported database:

System.Data.Common.DbConnection con =
this.command.Connection as System.Data.Common.DbConnection ;

if ( con != null )
{
System.Data.DataTable temp = con.GetSchema
(
"TABLES"
) ;

temp.DefaultView.RowFilter = "TABLE\_TYPE='TABLE' OR TABLE\_TYPE='BASE TABLE'" ;
temp.DefaultView.Sort = "TABLE\_NAME" ;

[jschell]

yuvarajujogi wrote:

How to check whether a database has a table out of that database

What are you going to do if it doesn't?

[Mohibur Rashid]

Hey, What database are you talking about? MySQL, Microsoft SQL Server ORACLE ....

[yuvarajujogi]

Sql Server

[Mohibur Rashid]

Once Again, What version of SQL Server? SQL Server 2000 SQL Server 2003 or What?

[yuvarajujogi]

I want to create a table in that database similar to the table in another database.

[Lost User]

You can use this code to check if a table exists.

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyTable]') AND type in (N'U'))
PRINT 'MyTable exists.'
ELSE
PRINT 'MyTable does not exist.'

[Karthik Harve]

try with this..

If Object_ID('dbo.MyTable') IS NOT NULL
PRINT 'MyTable Exists'
Else
PRINT 'MyTable Not Exists'

with regards Karthik Harve

[Karthik Harve]

try with this..

If Object_ID('dbo.MyTable') IS NOT NULL
PRINT 'MyTable Exists'
Else
PRINT 'MyTable Not Exists'

with regards Karthik Harve

[Lost User]

If there is a view or stored procedure with the same name, this script will fail.