c# use tablename as variable

Question

How can i use tablename as a variable in sql query?

"select * from table_name "

table_name must be variable.

Answer 1

Hi @ÖMER NASUHİ KESKİN

Your title and content are somewhat conflicting, and I don't see anything to do with C# from the content. Like Olaf said, you can try dynamic SQL. You can refer to the content in this link.

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver16

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Sometimes you can use an approach like this:

if @variable = 1
   select * from Table1
else if @variable = 2
   select * from Table2
else
   select * from Table3

Answer 3

How can i use tablename as a variable in sql query?

That's not really possible, object names must be fix, you can not use a variable instead.

One option is dynamic SQL, but belief me, you don't want that. See The Curse and Blessings of Dynamic SQL

You use C# tag, in which way is it related to?

Answer 4

In addition to the other answers: there is a fair chance that your desire to have a dynamic table is due to an incorrect design. Maybe all those many tables should be a single table with one more key column.