Search
 
SCRIPT & CODE EXAMPLE
 

SQL

list of all table names in sql server databse

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

PREVIOUS NEXT
Code Example
Sql :: mysql get last insert id 
Sql :: sql first 
Sql :: alter table add multiple foreign key sql 
Sql :: create index mysql 
Sql :: sqlite indexes 
Sql :: mysql where not equal 
Sql :: how to calculate number of days between two dates excluding weekends in oracle 
Sql :: describe in sqlite3 
Sql :: how to check table exists or not in postgresql 
Sql :: import mysql dump command line 
Sql :: mysql current time 
Sql :: Msg 241, Level 16, State 1, Line 12 Conversion failed when converting date and/or time from character string. 
Sql :: postgres list users and roles 
Sql :: connect mysql command line 
Sql :: oracle list grants on procedure 
Sql :: install mysql on ubuntu 
Sql :: sql server datetime to string 
Sql :: Select without null values sql 
Sql :: create function syntax sql server 
Sql :: sum sqlalchemy 
Sql :: SQL ORDER BY ASC (Ascending Order) 
Sql :: SQL UNION ALL Operator 
Sql :: dual in db2 
Sql :: oracle partition table row count 
Sql :: create table in sql server 
Sql :: sql server last character in string 
Sql :: get cpu details sql 
Sql :: postgres 11 add primary key 
Sql :: sql database connectivity 
Sql :: createdb with postgresql on ubuntu 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =