SQL QUERIES: Ans me the below quries

1)How to fetch all the tables from DB using sql statement?
2) What is "\" in Sql server?(Ex SQL>\)
3) SQL>@ABC While running above statement what will you get the result?
4)How to delete the 3row 3rd column in a table? without giving any value?

Tags: Reply, answers, me, the

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by lakshmi on March 22, 2010 at 3:37pm

Hi, Thx mohan.

▶ Reply

Permalink Reply by Bhakti Banawalkar on March 22, 2010 at 3:57pm

Hi Lakshmi to fetch all the tables from DB using sql statement you can use
select * from tab;

▶ Reply

Permalink Reply by Priya Singh on March 22, 2010 at 4:53pm

I think select * from tab is for Oracle !! Does it also works in SQL server ? Moreover it may fetch all tables from tyeh base directory/ db......One needs to be within a particular database to fetch the table names from that very database...!!

Please correct me if I m wrong!!