Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial. In this video ,we will generate the script that will return us all the table names with column names and data type of those columns. We often need this information. Let's say we are going to prepare mapping document for load the data from Source Database to Destination database. We can get the list of all tables with column names and data types from Source Database and Destination Database and then paste in Excel and map the required input columns to output columns for ETL Process.
Blog link with scripts used in video
Tags: Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial, Table Name, Column, Names, Data, Types, System Views, System Tables, SQL, Server, Developer, TSQL, DBA, Interview, Scripts, DBA Tips, SQL Developer, SQL Server Interview Questions, TSQL Interview Questions and Answer, transact sql, SQL Server 2014, SQL SErver Adavance Tutorial, SQL Server Tutorial for beginners, Tech Brothers