Q&A for professional and enthusiast programmers
SELECT * FROM sys.Tables -- SELECT * FROM INFORMATION_SCHEMA.TABLES -- sp_help 'Users' -- select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Users'