Gokuldas Palapatta

This blog is all about the issues and frictions which i have faced as a developer ;)

Thursday, 10 September 2015

Get all Table names from my DB in SQL


Get all Table names from my DB in SQL


SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='DB'
Posted by Gokuldas Palapatta at 03:17
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Gokuldas Palapatta
View my complete profile

Blog Archive

  • ►  2018 (2)
    • ►  February (2)
  • ►  2017 (5)
    • ►  July (1)
    • ►  April (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2016 (9)
    • ►  December (1)
    • ►  September (1)
    • ►  July (1)
    • ►  June (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ▼  2015 (56)
    • ►  December (3)
    • ►  November (6)
    • ►  October (1)
    • ▼  September (2)
      • Create a Div control dynamically in C# Asp.net
      • Get all Table names from my DB in SQL
    • ►  August (1)
    • ►  July (8)
    • ►  June (5)
    • ►  May (8)
    • ►  April (6)
    • ►  March (3)
    • ►  February (6)
    • ►  January (7)
  • ►  2014 (1)
    • ►  May (1)
Awesome Inc. theme. Theme images by wibs24. Powered by Blogger.