print sql DB

Question

Hi I need to print of a list which have all the fields name and datatype of all tables from a particular sql database in a order.

Upendra Pratap Shahi · Answer

Hello Ankit Shukla  After running the query right click on result and there is an option for print . from this you can print your report from SQL directly. Kindly accept the answer for better discussion on forum.

Upendra Pratap Shahi · Answer

Thanks a ton Ankit Shukla for appreciation.

Ankit Shukla · Answer

Thanks Sir..

Ankit Shukla · Answer

Hi Thanks to all. But Its not matter of concern. i need print out. there is any option in sql server to print this report.

Upendra Pratap Shahi · Answer

SELECT QUOTENAME ( SCHEMA_NAME ( tb . [schema_id] )) AS 'Schema'  QUOTENAME ( OBJECT_NAME ( tb . [OBJECT_ID] )) AS 'Table'  C . NAME as 'Column'  T . name AS 'Type'  C . max_length  C . is_nullable FROM SYS . COLUMNS C INNER JOIN SYS . TABLES tb ON tb . [object_id] = C . [object_id] INNER JOIN SYS . TYPES T ON C . system_type_id = T . user_type_id WHERE tb . [is_ms_shipped] = 0 ORDER BY tb . [Name]

Sumit Joshi · Answer

Hi Ankit In SQL server we have DB_Name database for all information about the database created on SQL Server You can explore to this database and use the required fields as per your requirement. Thanks buddy. If it is helpful Mark it Correct Answer

Manas Mohapatra · Answer

Please follow below query: USE DBName ; SELECT table_name as TableName  column_name as 'Column Name'  data_type as 'Data Type'  character_maximum_length as 'Max Length' FROM information_schema.columns;