Query??

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

SELECT * FROM INFORMATION_SCHEMA.TABLES

bersileus sacamay-126226 SSChasing Mays Points: 642 More actions · Answer 2

i would go for what cris has done, pretty nifty, but here are other options using sp, this is pretty nice sp. look it up msdn BOL

use northwind

go

sp_tables null,dbo, null, "'TABLE'"

go

sp_tables null,dbo, null, "'TABLE', 'VIEW'"

go

sp_tables

--hope this helps

bersileus sacamay-126226 SSChasing Mays Points: 642 More actions · Answer 3

an addition to this just in case you want to manipulate the data

--DROP TABLE #QUERY

CREATE TABLE #QUERY

(

TABLE_QUALIFIER VARCHAR(100) NULL,

TABLE_OWNER varchar(100) NULL,

TABLE_NAME varchar(100) NULL,

TABLE_TYPE varchar(100) NULL,

REMARKS VARCHAR(100) NULL

)

GO

INSERT INTO #QUERY EXEC sp_tables null,dbo, null, "'TABLE', 'VIEW'"

go

SELECT * FROM #QUERY

Jan Yaqoob-226702 SSC-Addicted Points: 403 More actions · Answer 4

Thanx for all of your kind replies, I am really happy to get the solution.

Thank you very much.

Thanx + Regardz,

Jan whY? Jan