How To List The Column Names Of A Table On SQL Server
Read Time:26 Sec
We all know that most database tables in EnterpriseOne have a large number of columns. In fact, they usually push the limits of the RDBMS.
Well sometimes, you need a list of those columns for things like INSERT statements.
Below is how you can get the column names from a table in a SQL Server database:
USE JDE_PY910 SELECT [name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = 'U' AND [Name] = 'F98950')
You can use either type V (views) or U (tables).
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating