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?
SELECT * FROM INFORMATION_SCHEMA.TABLES;
SELECT * FROM INFORMATION_SCHEMA.COLUMNS;
SELECT * FROM sys.tables;
SELECT OBJECT_NAME(OBJECT_ID) AS TableName,* FROM sys.columns;
List of all tables & columns in my db?
Posted - 02/27/2013 : 11:02:34
