SQL Server 2005 Metadata

[N002213F]

Does SQL Server 2005 have system tables that you can select to see meta data about a table? I have seem such tables in Oracle.

I would like to retrieve certain tables properties for analysis and comparisons

Any pointers most appreciated

[debasisdas]

yes those are also available here.

[N002213F]

Some names or web page might help.

Thanks in advance

[ck9663]

Depending on the version of SQL Server you're working on, there's a table called sysobjects.

If you're working with SQL 2005, there's a view called sys.tables

So, try the following:

select * from sys.tables
 
select * from sysobjects

-- CK

[N002213F]

Found it;

SELECT NAME FROM SYS.TABLES ORDER BY NAME

and

EXEC SP_SPACEUSED[TABLENAME]

I used Java to do the the looping, will look at using SQL procedures.

[N002213F]

Depending on the version of SQL Server you're working on, there's a table called sysobjects.

If you're working with SQL 2005, there's a view called sys.tables

So, try the following:

select * from sys.tables
 
select * from sysobjects

-- CK

Thanks, if selecting from the sysobjects, one may have to specify the type, lest you get all the objects.