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

[Thehavemans]

Love this. How would I edit this code to exclude empty Tables (ie Tables with columns but no rows/records)?

[alwalravi]

could you please help, how to find Object dependencies along with which column exactly is dependent (need column also). Please share the query for this in sql server.

[thohayvietnam]

i want to export data of table into txt file, please by using query ( not handing)

[radhakishansharma]

Is it possible to get table name and column name on excel from access db through SQL query? If possible then please help me out.

[brandonher]

How would you search up a specific column name once you use this query?

Where columnName is ('columnName'l ?

[osamasallam]

you are showing the views by using : select * from sys.tables
but how to show the Tables only in DB?

[goodmorningandwintoday]

hapana zviripo apa kkkk sorry for the language thats great , powerful explanation

[MauriceWilliams]

Wow! This is some deep stuff. Also your English is very good I understood what you were saying very well.

[sandeepkumarpentakota]

how to get table name and and column names in single row