Database

Use [YourDatabase]
GO

SELECT SC.NAME FROM SYS.objects SO, SYS.columns SC
WHERE SO.TYPE = 'U' AND SO.name LIKE '[yourTableName]'
	AND SO.object_id = SC.object_id
ORDER BY SC.name

USE {enter your desired database name here};

DECLARE     @NameOfTable     VarChar(128);
SET     @NameOfTable = '{enter your desired table name here}';

DECLARE @SQLStatement VarChar(8000);

SET @SQLStatement =  'SELECT ''' + @NameOfTable + ''' AS TableName';

PRINT @SQLStatement;

EXEC(@SQLStatement);

WITH TableColumns_CTE
AS
(
    SELECT   T.name     AS  TableName
            ,C.name     AS  ColumnName
            ,ROW_NUMBER() OVER (PARTITION BY T.name ORDER BY T.name, C.name) Seq
    FROM    sys.tables T
    INNER JOIN sys.columns C
       ON   T.object_id = C.object_id
      AND   T.name = @NameOfTable
)

SELECT   @SQLStatement = @SQLStatement + ', ' + ColumnName
FROM    TableColumns_CTE;

SELECT   @SQLStatement = @SQLStatement + ' FROM ' + @NameOfTable + ';';

PRINT @SQLStatement;

EXEC(@SQLStatement);

zead wrote:

Is it possible to secure sql database using user name password, not the mixed mode user name password, (user name password ) on database it self to prevent it when restore on other sql engine(instance).

zead wrote:

the second questions is how to hide columns on sql server database engines, when open the database can't see the tables and columns until i enter the database user name password

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

CREATE TABLE [cpqaAnswers].[cpqa].[cpqa_OT_tblRegister](
	[id][int],
		[school][nvarchar](15),
			[name][nvarchar](38),
				[Subject][nvarchar](45),
					[results][int],
						[studentID][int]
						)

BULK INSERT [cpqaAnswers].[cpqa].[cpqa_OT_tblRegister]
	FROM 'C:\Users\OT\registerOT(td)_.txt'

SELECT * FROM [cpqaAnswers].[cpqa].[cpqa_OT_tblRegister]
	WHERE [results] = 72
		ORDER BY [id]
			FOR XML PATH('Schools'), ELEMENTS, ROOT('Register')

<Register>
  <Schools>
    <id>5</id>
    <school>Cambridge</school>
    <name>john</name>
    <Subject>English</Subject>
    <results>72</results>
    <studentID>2</studentID>
  </Schools>
</Register>

<Register>
<Schools>
  <School>
    <Name>Oxford</Name>
    <Students>
       <Student>
          <Name>tom</Name>
          <Subjects>
             <Subject>
                <Name>Maths</Name>
                <grde>98</grde>
             </Subject>
             <Subject>
              <Name>English</Name>
              <grde>87</grde>
             </Subject>
            <Subject>
              <Name>Chemistry</Name>
              <grde>63</grde>
            </Subject>
         </Subjects>
      </Student>
   </Students>
 </School>
 <School>
    <Name>Cambridge</Name>
    <Students>
       <Student>
          <Name>john</Name>
          <Subjects>
             <Subject>
                <Name>Maths</Name>
                <grde>50</grde>
             </Subject>
             <Subject>
              <Name>English</Name>
              <grde>72</grde>
             </Subject>
            <Subject>
              <Name>Chemistry</Name>
              <grde>32</grde>
            </Subject>
         </Subjects>
      </Student>
   </Students>
 </School>
</Schools>
</Register>

character_set_client	utf8
character_set_connection	utf8
character_set_database	utf8
character_set_filesystem	binary
character_set_results	utf8
character_set_server	utf8
character_set_system	utf8
character_sets_dir	C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\share\charsets\
collation_connection	utf8_general_ci
collation_database	utf8_unicode_ci
collation_server	utf8_unicode_ci
completion_type	0
concurrent_insert	1
connect_timeout	10

<add name="SQLdb" connectionString="Server=xx.xx.xx.xx;uid=admin;pwd=xxxxxxx;database=xxxxx;Charset=utf8;" providerName="MySql.Data.MySqlClient"/>