To get table data

Question

To get table data

I want to get all table names and fields in this table from a specific database. Please help me solve this problem.

+5

sql tsql sql-server-2008 sql-server-2008-r2

Ramdas May 28 '12 at 12:04

source share

2 answers

use the syntax: -sp_help your table name

like this

sp_help Payroll_Shift

+2

atik sarker Dec 05 '13 at 5:47

source share

Darren davies · Accepted Answer · 2012-05-28T12:06:57+0000

Try to look at the tables sys.objectsand sys.columns:

SELECT * FROM SYS.OBJECTS
WHERE TYPE = 'U'

Would give you all the tables in this database (Type U)

SELECT 'Table name : ' +  so.name, ' Column Name: ' + sc.name FROM SYS.OBJECTS so
INNER JOIN sys.columns sc ON sc.OBJECT_ID = so.OBJECT_ID
WHERE TYPE = 'U'

Gives you all the tables in this database and column names. You can filter these queries and doWHERE so.name = 'Your Table'

http://msdn.microsoft.com/en-us/library/ms190324.aspx

To get table data

More articles: