Archive for the ‘Queries’ Category

Listing all columns of all tables

Posted: 11/11/2011 by murilomiranda in Queries
0

Hi guys! Here comes a simple script to show a list of all columns of each table in a database. It could be useful to help the know about database model. DECLARE @obj_id INT DECLARE @obj_name VARCHAR(300) DECLARE @columns AS VARCHAR(MAX) IF Object_id(‘tempdb..#tmp_table’) > 0 BEGIN DROP TABLE #tmp_table END CREATE TABLE #tmp_table ( table_name [...]