What is the best way to get the names of all of the tables in a specific database on SQL Server?

Whenever I design a database, Should table names be plural? Should column names be singular? Should I prefix tables or columns? Should I use any case in naming items? What are recommended …

SQL naming conventions are guidelines for naming database objects like tables, columns, schemas, indexes, and constraints. They help standardize names across a database, making it easier to read, …

Jun 25, 2024 · Table names can contain any valid characters (for example, spaces). If table names contain any characters except letters, numbers, and underscores, the name must be delimited by …

For static queries, like the one in your question, table names and column names need to be static. For dynamic queries, you should generate the full SQL dynamically, and use sp_executesql to execute it. …

Is it possible to query for table names which contain columns being LIKE '%myName%'

Mar 2, 2021 · As for table names being plural, as mentioned, many experts disagree strongly on this. Joe Celko, world-famous database expert and one of the authors of the SQL-89 and SQL-92 …

Dec 28, 2023 · The dynamic Table Name variable is a good method to handle table names dynamically and offers great flexibility. At the same time using dynamic table name can make the code less …

It is not a technical problem for the database to have uppercase letters in your table or column names, for any DB engine that I'm aware of. Keep in mind many DB implementations use case sensitive …

Jul 23, 2025 · Renaming a table is a common and useful operation for database administrators and developers. It is especially useful when we need to correct a naming mistake, organize our database …