Search notes:

SQL Server: sys.all_columns

sys.all_columns can be used to query about columns, their data types, precisions etc.
The following query joins with sys.all_views to select the colums from sys.all_columns:
select
   sc.name                    schema_name,
   vw.name                    view_name,
-- cl.column_id,
   cl.name                    column_name,
   tp.name                    data_type,
   cl.max_length,
   cl.precision
from
   sys.all_columns cl                                     join
   sys.all_views   vw on vw.object_id    = cl.object_id   join
   sys.schemas     sc on vw.schema_id    = sc.schema_id   join
   sys.systypes    tp on cl.user_type_id = tp.xusertype
where
   vw.name = 'all_columns'
order by
   sc.name,
   vw.name,
   cl.column_id;

See also

sys.columns

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740442312, '13.58.67.60', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL-Server/administration/schemas/sys/objects/views/all_columns(58): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78