/SQL/Get tables in database sql

Get tables in database sql

Get the list of all tables in sql server

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

13

Get tables in database sql

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;

0

Similar codes

0 vote189 views1 answer
How to add auto increment primary key
SQL
0 vote267 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote122 views3 answers
Read all columns of a table sql
SQL
0 vote135 views1 answer
Oracle sql add column auto generated value
SQL
2 votes141 views2 answers
Install sqlalchemy
SQL
0 vote119 views4 answers
Forenkey code alchemy sql
SQL
0 vote135 views1 answer
How to update sql server version
SQL
0 vote133 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote134 views1 answer
How to print some string in mysql
SQL
0 vote135 views2 answers
How to create a table from another table in sql derby
SQL

Share