Check if a SQL table exists in C#

Question

            var conn = new SqlConnection("");

            try
            {
                conn.Open();
                string s = $"SELECT Email FROM {tableName} WHERE {query}";
                SqlCommand cmd = new SqlCommand(s, conn);
                SqlDataReader reader = cmd.ExecuteReader();

                int email = reader.GetOrdinal("Email");                

                while (reader.Read())
                {
                    var response = new User
                    {                       
                        Email = reader.IsDBNull(email) ? null : reader.GetString(email)
                    };
                    emailList.Add(response);
                }

                reader.Close();
            }
            finally
            {
                conn.Close();
            }

How do I update this code to verify if a table with name {tableName} exists in sql database before executing this code.

Does this answer your question? Is there an way using ADO.NET to determine if a table exists in a database that works with any data provider? — Berkay Yaylacı
– Berkay Yaylacı, Commented Mar 29, 2022 at 21:46
There are several ways how to check it table exists in the database: database.guide/… — Tomas Paul
– Tomas Paul, Commented Mar 29, 2022 at 22:15

Mohammad Mirmostafa · Accepted Answer · 2022-04-14 11:55:46Z

1

Run the following query and substitute {tablename} with the name of the table, you are looking for:

SELECT name, SCHEMA_NAME(schema_id) AS [schema], create_date, object_id, modify_date FROM sys.tables WHERE name = {tablename}

answered Apr 14, 2022 at 11:55

Mohammad Mirmostafa

1,7752 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check if a SQL table exists in C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related