gettting table name

[saqib82]

Hi how can i query the name of all the tables existing (except system tables) in a database using sql server 2000. regards

sAqIb

[AETaylor]

select * from sys.sysObjects where type = 'U'

[Bright Zhang]

select name from master..sysobjects where type = 'U'

[quiteSmart]

hi you can use this to get only the names of the table with no other coloumns. Select name From sisobjects where type = 'U' if you need anything else fell free to contact me on MSN: jamilaboukhalil@hotmail.com Jamil abou khalil