SQL Script for find Table Names and Columns or Fields Name of a Specific Table

To Find the name of the tables name need to write this script:


SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

To Select Names of the Fields or Columns of Specific Table by Name(SQL Script):

SELECT [name] AS [Column name]
FROM syscolumns
WHERE id = (SELECT id
FROM sysobjects
WHERE type = 'U'
AND [NAME] = 'Table_Name')