Member Avatar for else_harpal

how can i find the table names from Sql server. what r the statement.

  • 3 Contributors
  • 2 Replies
  • 95 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by sknake

Recommended Answers

All 2 Replies

Member Avatar for Thirusha 
use DATABASE_NAME

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
Member Avatar for sknake

I didn't know about INFORMATION_SCHEMA.Tables ;)

I have used this in the past:

Select name
From sysobjects
Where Type = 'u'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.