Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

MS sql system table

2 Posts 2 Posters 0 Views 1 Watching

B Offline
B Offline
billcodes

wrote on last edited by

#1

hi, Which system table in the MS sql hold the information about the user created tables? regards, Bill
W 1 Reply Last reply

0
B billcodes

hi, Which system table in the MS sql hold the information about the user created tables? regards, Bill
W Offline
W Offline
Wendelius

wrote on last edited by

#2

Hi, It depends on what information you're looking for and what version of SQL Server you're using. If you're using 2005 or higher, you could use:

select * from sys.tables

The need to optimize rises from a bad design.My articles[^]
1 Reply Last reply

0

Log in to reply