print sql DB

Ankit Shukla

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Accepted 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.
+1
Upendra Pratap Shahi11y ago
Thanks a ton Ankit Shukla for appreciation.
0
Ankit Shukla11y ago
Thanks Sir..
0
Ankit Shukla11y ago
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.
0
Upendra Pratap Shahi11y ago
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]
0
Sumit Joshi11y ago
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
0
Manas Mohapatra11y ago
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;
0