Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jodders
Starting Member
41 Posts |
 Posted - 2013-02-27 : 11:02:34
|
| Hi guys,I plan on having a clear up on my Database which has hundreds of tables that I have created and I really need to do a bit of housekeeping. Is there a way of displaying them via SQL or outputting them all into Excel?Your help is most appreciated.ThanksJodders |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-27 : 11:20:41
|
Any of these.SELECT * FROM INFORMATION_SCHEMA.TABLES;SELECT * FROM INFORMATION_SCHEMA.COLUMNS;SELECT * FROM sys.tables;SELECT OBJECT_NAME(OBJECT_ID) AS TableName,* FROM sys.columns; |
 |
|
|
jodders
Starting Member
41 Posts |
Posted - 2013-02-28 : 04:13:24
|
| Cheers buddy, that did the trick |
|
|
|
|
|
|
List of all tables & columns in my db?