Listing columns using sys.columns, and creating a SELECT statement JOINing three tables
How easy is it to list columns in every table in your database? Very easy.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
In this video, we'll have a look at the sys.columns system table. We'll also see how it can be joined to the sys.types and sys.objects tables.
The final code that we develop is:
SELECT T.[name] as Type, SCHEMA_NAME(O.schema_id) + '.' + object_name(C.object_id) as ObjectName, C.*
FROM sys.columns AS C
LEFT JOIN sys.types AS T
ON C.system_type_id = T.system_type_id AND C.user_type_id = T.user_type_id
LEFT JOIN sys.objects AS O
ON C.object_id = O.object_id
Смотрите видео Listing columns using sys.columns, and creating a SELECT statement JOINing three tables онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал SQL Server 101 25 Ноябрь 2021. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 4,074 раз и оно понравилось 36 посетителям.
